Print multiple invoice from data

[bigdadi]

Want to know how ...

Say I have 10 data each row (A1 : A10) with Invoice No, Company Info
etc

Currently I have to copy and paste data row to one specific row tha
was linked to Invoice worksheet, then I go to Invoice sheet and prin
that invoice, and come back to data worksheet copy and paste a new ro
of data to that specific row.

Is there a simpler way to auto print 10 invoices by just one prin
command in Invoice sheet after I told excel the data rows are in cel
range (A1 : G10

 

[Don Guillett]

Just record a macro to do it and then you can see what happens. Then clean
it up

 

[Debra Dalgleish]

You could mark the invoices that you've previously printed, and use a
macro to print invoices for the the records. There's a sample here:

http://www.contextures.com/excelfiles.html

Under the Function heading, look for 'Print Unmarked Invoices'