Printing issue

Originally Posted by wally

I have sheet1 with all my data A1:D1, sheet2 is a form filled out based on the data from sheet1 and printed. I need to setup a script so if i have 50 rows of data it will print 50 pages(forms) with the correct data.

The data in sheet1 is organized, but the cells in sheet2 are not.


sheet2 A5= sheet1 A1
sheet2 C7= sheet1 D1

and so on, I can make the links easy if it was always one page a day.
but it can range from 25-50 pages a day.

thanks for any help.

Hi,

easiest for you would probably be the Mail Merge, use the 'Letters' option and feed in the required number of rows.

see http://www.gmayor.com/mail_merge_lab...th_word_xp.htm


hth
---

Originally Posted by wally

Microsoft Word is not avalible at work, really dumb but all we get it excel and outlook,

that for the help anyways,

that's ok - all is not lost, you just need a small macro that starts the print (ie, I presume that you have a print layouot already set), and just feed that with the row numbers and let it print.

To get a macro, Tools, Macro, Record New Macro, select your row, then go through the print moves, then select your next row.
Stop recording and post the code here with the request that someone add a 'Do' loop to go from row ~ to row ~~ (row numbers in A1 & B1 etc?)

hth
---