Hello folks!
I'm learning slowly how to write simple macros, and always find lots of useful information from previous questions on this and other forums, thank you!
I have posed myself a task to make my life easier whilst at work that I hope you can help me with?
I have a spreadsheet that I use to keep track of consultation periods on for any type of change at work, for instance terms and conditions, or redundancies.
I have used a simple formula to give me a count of how many live consultations I currently have ongoing on the register as at when it is opened each time, but I would like the ability to forecast forward.
I would like to do this by writing a simple macro that does the following:
- Open the consultation register.xlsx
- Ask for a date in an input box
- Insert date from input box into cell B7 of the consultation register.xlsx
- Compare each of the rows with a blank cell in column U and, if the date in column T is earlier than the date in B7, insert the date from column T.
- Save the file using a saveas box prefilled with the title consultation register as at [date in cell B7]
Would any kind individual help point me on the right track please?
I have attached the spreadsheet in question (excel 2010), there are currently no macros within, just formulae.
Consultation register.xlsx
Your assistance is much appreciated. Thank you.
Bookmarks