Help creating macro to open a new tab, transfer Heathers, transfer require row and update the Date in the new tab
Hi could you please help me with the creation of a macro? I’m working on the creation of an schedule.
Attached is an example, please note that original document will contain more columns and rows. I have an excel doc with a tab call “Calendar 2016”, and for columns (Name, Code, Cleaning Date, Completed Cleaning Date, Address). The cleaning services will happen once a year at the same location.
Cleaning date - Is the date where the cleaning will start
Completed Cleaning Date – Is the date where the Cleaning will end
This is what I require as the cleaning services will happen once a year in each location:
1 – I would like for example for the first row (House), as soon as I enter the (Completed Cleaning Date), a new sheet will be created with the name (Calendar 2017) all the heathers are transferred automatically.
2 – All the info in row 2 must be transferred to the first empty row in the sheet (Calendar 2017) except for the (Cleaning date and Completed Cleaning Date).
Cleaning Date (in Calendar 2017) will be the Completed Cleaning Date (in Calendar 2016 +1 year).
For example if in the sheet (Calendar 2016) the House Completed Cleaning Date is 31/03/2016 in the sheet (Calendar 2017) the Cleaning date will be 31/03/2017
3 – This will happen every year so the field (Completed Cleaning Date) will be empty until I input something manually and always it will open a new sheet
Please if you see a better way of doing this I’m open to new options
Thank you in advance