Excel: Printing multiple copies with differing values

[Dyl]

Hi all,

Sorry if this has been done before, but is there a way of printing off multiple copies of the same worksheet in Excel, but with, say one, cell differing in value each time?

I have no knowledge of programming with Excel, so if it requires that kind of input I will just have to find another way I think.

Thanks in advance, Dyl

[Dyl]

There are actually two cells which will be changing, one is a date that I was hoping to print off with a weekly change, e.g. 30/07/2012, 06/08/2012, 13/08/2012, etc. The other is simply a number, changing by the same amount each time, e.g. 100, 200, 300, etc.

I am (still) using Excel 2003.

Thanks

[Dyl]

SystemParanoia said:

can you not import it into word and do a mailshot?

I had completely forgotten it could be done in Word (I have never had any need for something like this since my Computing course in school 6 years ago). I will give that a try and hopefully it should work, cheers!

[Dyl]

mrmr96 said:

This can be done with a macro.

Or, you could setup your document so that you have multiple tabs in your workbook, which are identical appart from those things you want to change. Then print all the pages.

Or, you could setup a single worksheet, with identical cell ranges side by side, and set the print ranges so that each set falls on a different page of the print out. Then print all the pages.

The best answer depends on how many copies you want and how complex the rest of the page is, and what your experience level is with excel.

My experience is probably enthusiastic amateur, I like to try and use the functions when possible but it's mostly trial and error. I have no experience of macros.

It's not essential, I am just being lazy and trying to find a way of doing it without having to type it all out. I will be needing 52 different sheets.

Thanks for the suggestions