Arielllllll
New Member
Hi all,
I have a column in a table that I would like to keep updated in one spot.
I would like to use that column in a different sheet, in a different table, that I add other columns too.
Ideally, if I add/delete/modify the column in the first sheet, the second sheet is updated too.
Can excel do this?
I've tried pivot tables, but the additional columns can't be calculated, they need to be added, and I can't add columns to pivottables.
I've tried linking the column in the first table to a second sheet, but when I sort the table, the second sheet is also re-sorted, but since it's not a table, it's incorrect.
For instance: I have a list of customers as part of a table on Sheet 1, with details about their addresses.
On Sheet 2, I want that same list of customers with details about their orders.
I have a column in a table that I would like to keep updated in one spot.
I would like to use that column in a different sheet, in a different table, that I add other columns too.
Ideally, if I add/delete/modify the column in the first sheet, the second sheet is updated too.
Can excel do this?
I've tried pivot tables, but the additional columns can't be calculated, they need to be added, and I can't add columns to pivottables.
I've tried linking the column in the first table to a second sheet, but when I sort the table, the second sheet is also re-sorted, but since it's not a table, it's incorrect.
For instance: I have a list of customers as part of a table on Sheet 1, with details about their addresses.
On Sheet 2, I want that same list of customers with details about their orders.