Print Macro Question - One form, multiple page prints with a single change for each.

This has been bugging me for some time, and because I do not have much to any programming experience in VB, reverse engineering examples I've found online has failed me, miserably.

I have a spreadsheet which is nothing more than a form brought over from Word. I have 100 procedures that need to be retired. Each procedure will require a cover sheet. The cover sheet is the form I loaded into excel.

Sheet1 of my spreadsheer is the retirement form itself, with a single cell, D7, which is a dropdown box. The list of items which populate that dropdown box are on Sheet 2, cells A1 - A100. The names of the procedures are in cells A1 - A100.

The "Form" is the retirement page for procedures. All I want to do is find a way to print the form page so that ALL the names of the 100 procedures will print out with an individual sheet.

Does this make sense?

Thank you,

Hal

Hi All,

Saw another person ask a question, and they included an image of their file. Hope this helps.

form.jpg

Does anyone have any ideas on this?

Originally Posted by chubbychub

so you just want to make a macro and print out multiple sheets with new data ?

Yes. That data is on Sheet 2, and I want the single cell to be changed to that date with each paper printed on Sheet 1.

Can you help me out?

I am not sure if is this simple that you are asking but here is the code for the macro:

Please Login or Register  to view this content.