Print each cell on a seperate sheet of paper

I have a list of specific codes that I want to print on promotional cards but I want each card to print with a specific code for the customer. I want to, basically, be able to set it up so when I hit print and each cell is printed on a separate piece of paper. Is there any way to set this up without hitting print a thousand times?

Hi

Have you tried a Google search!

Yep,

I have been finding the same thing. I do not know if I need to setup some sort of equation or programing to get this to work. If I have to hit print thousands of times, then I guess I will have to.

Perhaps a macro like this?

Please Login or Register  to view this content.

This will print each cell values in A1, A2, A3 and A4 to a separate sheet. You would probably have to adjust margins (Page Setup)

Alf