Sorting sheets from a Master Sheet

**pdizzy** · 07-16-2014, 01:41 PM

Hi

I have a spreadsheet that covers 2 sheets for each day and 1 sheet which holds all the Master Data. Each of the daily sheets refers to a cell on the Master Data sheet such as =ALL!C5. The problem is that if we sort anything on the Master Data sheet each daily sheet does not get sorted. How can we solve this so that if the Master Data sheet is sorted that all the daily sgeets would also get sorted?

THK in advance.

PD

**hoyasaxa215** · 07-16-2014, 02:01 PM

Can you upload a sample file demonstrating your issue?

**pdizzy** · 07-16-2014, 02:10 PM

Hi

Uploaded to my OneDrive:-

see below post

Click the drop down 'EDIT WORKBOOK' and then edit in Excel which will let you download and edit offline in your version of Excel.
Thx

**hoyasaxa215** · 07-16-2014, 03:01 PM

Can't access that site. Can you just upload it through the forum? Click on "Go Advanced" and then click on the paper clip icon.

**pdizzy** · 07-17-2014, 10:53 AM

If I do a SORT of the MASTER DATA (ALL) then all the data is sorted on the MASTER DATA (ALL) sheet is sorted. If I cut and paste only the MASTER DATA (ALL) worksheet gets pasted to where I want and the others stay the same. This can be seen in the spreadsheet.