Quote:
Originally Posted by Bekki
I work with 2003. Every week I print out this workbook which contains scatterplots. I have to change the date every week in seveal places manually. Is there any way to do this either automatically or someway I can change one and simulataneously change all the others at the same time? Or is there just a plain quicker easier way to do this? Attached is a sample of the scatterplots. I'm not great with Excel but passable. Any help will be appreciated.
|
Are your dates in cells in various worksheets, or within the plots themselves? If the former, =Today() will always give you the current system date. Of course, if you print the workbook today it'll show 9/8/2010, and if you print the same workbook tomorrow it'll show 9/9/2010.
If the dates are within the plots, that function might also work, don't know for su try something like setting the title of the plot to
"TITLE OF MY PLOT AS OF " & Today() and see what happens