Automation Copy Rows for a set of files generated with "Save As New..."



I have created a template folder where I have several sheets linked together and, in one of them, rows are copied automatically into an "History" sheet when there is a change.

However, when I do a "Save as new.." to create a new folder, the Automation of the sheet remains linked to the original "History" sheet and is not linked to the new "History" sheet located in the new folder.

Do you have any idea about how to solve this?

Thanks a lot

Best regards


Best Answer