I created a Budget template using Excel. The tabs are all duplicates of one another and are listed as 'Year 1', 'Year 2', 'Year 3', etc. I would like to be able to enter data into the 'Year 1' tab and have it duplicated into the 'Year 2' tab and then be able to change the data manually if needed and then copy that revised data from the 'Year 2' tab into the 'Year 3' tab.
Is there any way to do this using a Macro function?
Is there any way to do this using a Macro function?
