Print invoice based on data entered in to a section on another sheet

[internalglitch]

Hello,

I have sheet 1 that has 6 input sections on it look like 6 forms and a single print button and the second sheet has 6 invoice templates lined up vertically on it. I am trying get it to work when you enter data in one or all sections on sheet 1 and click the print button it print 2 copies of each invoice on sheet 2 based on if data was entered in to that section. So if only data was entered in section 1 on sheet 1 then the first invoice would print only and if 2 sections on sheet 1 had data then invoice section 1 would print the first invoice template and the 2nd data section goes to the second template that should be printed. I don't want the remainging templates to print if no data was entered in on sheet 1.

Thanks

[internalglitch]

I know this doesnt work but may give some idea of what i'm trying to accomplish.

Please Login or Register  to view this content.

On the if range equals I'm looking for any value text or numerical. I need two copies printed if that range has any data.

Thanks

[internalglitch]

Can someone give me an idea how to accomplish this please. Nothing I seem to do works fully. Thanks