Linked multiple cells, arrays and precedent cells re-sorting

Eusr

New Member
Joined
Aug 21, 2020
Messages
3
Office Version
  1. 2019
Platform
  1. 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
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,127,105
Messages
5,622,764
Members
415,926
Latest member
jerrynababa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top