Hi there,
I export an XL template from an erp system. I cannot edit any of the data within this sheet (as I'm uploading it again and this sheet cannot be changed). So I need to make a copy of the sheet and format this sheet as a table.
How can I link the 2nd sheet to the 1st sheet so that it updates sheet 2 with any new rows of data that may be populated within sheet 1 but still keeping sheet 2 as a table.
Thanks
I export an XL template from an erp system. I cannot edit any of the data within this sheet (as I'm uploading it again and this sheet cannot be changed). So I need to make a copy of the sheet and format this sheet as a table.
How can I link the 2nd sheet to the 1st sheet so that it updates sheet 2 with any new rows of data that may be populated within sheet 1 but still keeping sheet 2 as a table.
Thanks