You can view the page at http://www.excelguru.ca/forums/conte...standing-Dates
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
I work at a hospital in the birthing center. I created a form which I need to print one copy for every day of the year so the staff can write in appointments for induction patients. I entered 1/1/2018 in cell A1. I then copied these rows (so keeps all formatting etc) and entered =A1+1. How can I now copy this so I can autofill for 365 days of the year so I do not have to manually copy this sheet 365 times? Thank you so much for any help with this!!
Bookmarks