Hi,
I'm very new with using loops and my VBA knowledge is getting there, although rather slowly . But most of what I have learnt is from this forum, so as always thank you.
Every year I have to create a holiday tracker and it can be quite laborious having to copy and paste formula's all the time so I thought with the knowledge that I have gained I could automate it every year by a push of a button and changing the start and end dates.
Most of it I can do but then I hit a snag. I can't seem to loop through the columns so that when it hits the 31/01/2022 or greater the the loop ends.
I kind of played around with the 'do while' but still can't get it to work But as I said, looping is pretty new to me.
I attach a sample worksheet to show what I want it to do and have left some simple formula's. In theroy each column header will show a workday for the entire year upto the end date from cell A1 to cell A2.
Any help as always will be greatly appreciated
Bookmarks