Help creating macro to open a new tab, transfer Heathers, transfer require row .....

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

Re: Help creating macro to open a new tab, transfer Heathers, transfer require row ..

Hi Guys any help transferring the rows as per criteria "Completed" from sheet Calendar 2016 to sheet Calendar 2017?

also when rows are transferred I would like that the cleaning date column from sheets Calendar 2017 would be the Completed Cleaning Date from sheets Calendar 2016 plus 1 year

all the help is appreciated