N
Neon520
Hi everyone,
I have a spreadsheet (Sheet1) that has all the information. Col A.
identify the location (ie. A, B, C...) What I essentially need to accomplish
is the separate those data into its one separate sheet (in the same workbook)
according to col. A as identifier. And I'd like to update any changes ONLY
in Sheet1 and the rest of the sheets will automatically change accordingly.
I was thinking of "paste link" but obviously it's not working, so that's why
I'm asking to see if anyone can help me.
I know that this can also be set up in reverse: set up a whole bunch of
sheets separately and have a REVIEW sheet at the end and update the whole
bunch of sheets according to where the change is applicable and have the
REVIEW sheet update automatically, but this is not what I'm looking for.
Also, I don't mind setting up all sheet sheets manually, so it doesn't have
to be Macro. I just need the changes updated automatically down the road.
Thank you so much,
Neon520
I have a spreadsheet (Sheet1) that has all the information. Col A.
identify the location (ie. A, B, C...) What I essentially need to accomplish
is the separate those data into its one separate sheet (in the same workbook)
according to col. A as identifier. And I'd like to update any changes ONLY
in Sheet1 and the rest of the sheets will automatically change accordingly.
I was thinking of "paste link" but obviously it's not working, so that's why
I'm asking to see if anyone can help me.
I know that this can also be set up in reverse: set up a whole bunch of
sheets separately and have a REVIEW sheet at the end and update the whole
bunch of sheets according to where the change is applicable and have the
REVIEW sheet update automatically, but this is not what I'm looking for.
Also, I don't mind setting up all sheet sheets manually, so it doesn't have
to be Macro. I just need the changes updated automatically down the road.
Thank you so much,
Neon520