Hi everyone,
I have a workbook in Excel 2013 whose sheets I print off once a week. The only data that changes on the sheets is the dates. For example, Cells A5 - A12 have 1/1/16 through 1/7/16 on them. With a macro or VBA, can I get those cells to automatically populate the next 7 days?
Griffin
Do you really need VBA? A formula takes care of every cell except the first.
A5 - starting data. You could use a TODAY() formula like
=TODAY() (shows today's date automatically)
=TODAY()+1 (shows tomorrow's date automatically)
Then in A6:
=A5+1
Copy A6 down to complete the week.
So only need to update A5 and print.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks