Hi Everyone,
Im trying to create a form on excel that will automatically update specific information onto a master spreadsheet.
I am issuing multiple forms with the same format. Sheet 1 is the master sheet used to track all the forms that are being issued. When adding a new sheet I need a blank form to be the default layout. This will be recorded automatically in the master spreadsheet and enter generic information into the tracker such as form number, date and title.
Is there a way to automate this process as I am currently entering everything in manually.
Im trying to create a form on excel that will automatically update specific information onto a master spreadsheet.
I am issuing multiple forms with the same format. Sheet 1 is the master sheet used to track all the forms that are being issued. When adding a new sheet I need a blank form to be the default layout. This will be recorded automatically in the master spreadsheet and enter generic information into the tracker such as form number, date and title.
Is there a way to automate this process as I am currently entering everything in manually.