Printing a running date

[Kahm111]

Hello All!

I would like to create a macro that can print multiple dates on the same spreadsheet.

The desired output would look like this:

Copy 1 - Date: 7/8/13
Copy 2 - Date: 7/9/13
Copy 3 - Date: 7/10/13
and so on...

Would it be possible to create a macro that could run the next 30 or 60 days? (I've been scratching my head for the last week or so and google isn't returning any results; maybe because I can't figure out the correct term.)

Any help would be great.

[HaHoBe]

Hi, Kahm111,

if I fully understand you have a date in one cell of the sheet and print that sheet with a different date for 30 days. Adjust the address for the cell to suit and try (maybe change the counter to a smaller number when testing)

Please Login or Register  to view this content.

Ciao,
Holger

[Kahm111]

Hi Hahobe!

Thanks for your quick and friendly response. I'm familiar with formulas--not so much with coding. Would you mind explaining how I would get this particular code to work? I've inserted this into the code workspace for the spreadsheet.

Kahm

[HaHoBe]

Hi, Kahm111,

you may find the following quote helpfull:

How to install your new code

1. Copy the Excel VBA code
2. Select the workbook in which you want to store the Excel VBA code
3. Press Alt+F11 to open the Visual Basic Editor
4. Choose Insert > Module
5. Edit > Paste the macro into the module that appeared
6. Close the VBEditor
7. Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)

To run the Excel VBA code:

1. Press Alt-F8 to open the macro list
2. Select a macro in the list
3. Click the Run button

Ciao,
Holger

[Kahm111]

Holger,

THANK YOU SO MUCH! You are fantastic!

Thanks again,
Kahm

[HaHoBe]

Hi, Kahm111,

thanks for the feedback - please mark this thread as Solved via Thread Tools.

Ciao,
Holger