Good morning,

I have created a Excel file with two sheets, where in the first one information is entered in a request form and using a macro with an interactive button it is sent to the second sheet which autofills in a table with the information from the first one.

Is it possible to transfer or copy the second sheet in its entirety with the formulas and macro links to another file, so that it continues to autofill even though only the fill-in form remains in the first file?

I would like to deliver only the first file with the form to the customers who can fill in with the information to be sent, and I have my own file where I get the required information and handle it only.