Latest Lists

How can I take a list on excel and print the information on an existing form IE deal jacket?

What I'm trying to do is take information that I already have in a sheet (dept of transportation excel log) and have it print on a deal jacket, that I normally fill in the blanks. Is there a way to set up a sheet to recieve or "merge" the information I already have in and feed the deal jacket into the printer, then presto the information I aleady have in there prints in the correct spot and I don't have to cut and paste every field?

Public Comments

1. Yes, you can do this. Let's say the "deal jacket" is on a separate sheet in the same file as the dept of transportation log. Go to the blank cell on the deal jacket sheet that you want to fill in. - type = - go to the cell in the dept of transportation log that has that information - hit Enter - repeat with the other blanks to fill them in You can also do this the same way if deal jacket and the source data are in different files. Just make sure both files are open first. If you need more info, add more details or e-mail. Good luck. .