Eusr
New Member
- Joined
- Aug 21, 2020
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
I have a worksheet with 4 sheets, and a 5th sheet with all the data amalgamated. It's all text formatted.
Each of the first 4 sheets is an array of cells linked to a block of cells in Sheet 5. Sheet 5 is all precedent cells.
Now that I have linked all the cells so that any changes to Sheet 5 will be reflected in the relevant sheets 1, 2, 3 or 4, I want to change the order of the cells in the precedent sheet.
So far, precedent sheet 5 has been sorted in blocks of categories (one of four designations in a certain column), each of which has its own dependent sheet 1,2,3 or 4.
I'd like sheet 5 to be sorted according to criteria in a different column or columns.
Can I change the locations of the linked-to cells in precedent Sheet 5 and have them remain linked to/connected with unmoving locations in the dependent sheets, yet new values entered in the precedent sheet still update the dependent sheets?
Here's how I linked the cells between the sheets:
select dependent cell array
=Sheet5!A1.R100
SHIFT+CTRL+ENTER
Each of the first 4 sheets is an array of cells linked to a block of cells in Sheet 5. Sheet 5 is all precedent cells.
Now that I have linked all the cells so that any changes to Sheet 5 will be reflected in the relevant sheets 1, 2, 3 or 4, I want to change the order of the cells in the precedent sheet.
So far, precedent sheet 5 has been sorted in blocks of categories (one of four designations in a certain column), each of which has its own dependent sheet 1,2,3 or 4.
I'd like sheet 5 to be sorted according to criteria in a different column or columns.
Can I change the locations of the linked-to cells in precedent Sheet 5 and have them remain linked to/connected with unmoving locations in the dependent sheets, yet new values entered in the precedent sheet still update the dependent sheets?
Here's how I linked the cells between the sheets:
select dependent cell array
=Sheet5!A1.R100
SHIFT+CTRL+ENTER