Serial Number AND Ascending Date

[ElenaK]

Hi!!
I would be most grateful if someone can help me with a rather (at least for me) complicated macro.
I need to print the same excel sheet many times, each time I print, I need the copy to have a serial number and a serial date starting from where I have specified.
eg) Cell A1 from 10 to 40
Cell B1 from 01/01/2018 to 30/01/2018 (European format)
That would give me 30 copies where each would have a different date and serial number.

I have found how to print with serial number, I just can't figure out how to incorporate date.

I would really appreciate any help...

 

[James006]

Hello,

Why don't you post your current macro ... with your next message ...

Most probably ... you can have your Date in the Header or the Footer ...

 

[ElenaK]

Hi!!
It's a macro I found here...
For mypage=1 to 1000
range("A1").value=mypage ' A1 is the cell i have chosen for the number
activesheet.printout
next mypage

I need something similar for the date that works simultaneously with this (unfortunately I need the date in a cell and not in the Header/Footer)

I tried taking it further, but I'm not that skilled...

Thanks in advance for any help

 

[James006]

Hi,

If you need a Date to appear in a given cell ...

You can add it manually once ... or you can insert an instruction in your macro ...

HTH