Hi there,
I am working on a spreadsheet that contains about 300 rows of data with employee names, start dates etc on the first sheet, within a table. I want to have this same list of employees on the second sheet, and possibly the 3rd - so I can add extra data for each employee that I don't want to show on the first sheet.
I saw the suggestion to copy and then "paste links" and that works well except it doesn't automatically update when I add new rows within the body of the table on the first sheet. Is there a way of doing this?
Thankyou so much!
R
I am working on a spreadsheet that contains about 300 rows of data with employee names, start dates etc on the first sheet, within a table. I want to have this same list of employees on the second sheet, and possibly the 3rd - so I can add extra data for each employee that I don't want to show on the first sheet.
I saw the suggestion to copy and then "paste links" and that works well except it doesn't automatically update when I add new rows within the body of the table on the first sheet. Is there a way of doing this?
Thankyou so much!
R
