Sorry, I don't understand.

You said you would pull data from a "different worksheet" and place it on the
single sheet, changing the data with each copy printed.

What is the name of the "different worksheet" and do you want B10 & C10 from it
placed into sheet1 first copy printed then B11 & C11 placed into second copy
printed and B12 & C12 into third etc.?

What is the name of the sheet to print 30 times?

BTW...........B10:B40 is 31 cells, not 30

I will not be able to get back to you today but hang in and watch for one of the
"real" VBA experts to jump in with code.


Gord


On Sun, 14 Oct 2007 16:38:01 -0700, Jr. wrote:

Several cell references....

Specifically (just a few I can adjust as needed),

B10:B40 TO SHEET2 C4
C10:C40 TO SHEET2 E9


If you can get me this far, I think I can figure out the rest....been about
10 years since I did ANY programming....



"Gord Dibben" wrote:

It is doable through VBA but from where will you pull the data from sheet2 and
where will it be placed on each copy of sheet1 printed out?


Gord Dibben MS Excel MVP

On Sun, 14 Oct 2007 14:51:01 -0700, Jr. wrote:

What I am trying to do is use a single worksheet pulling data from a
different worksheet to print multiple copies of the original worksheet.
Similar to a mail Merge, but basically to copy a daily number and date from
the second sheet and use it as a variable on the first worksheet.

If this sounds complicated, I apoligize, but considered as a mail merge
would be the closest I could think of!

If I need to, I suppose I could copy the Original Worksheet 30 times, and
put a cell reference into each, just seems like a lot of work---Kinda lazy ya
know!


Thanksl!