Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATA FOLLOWING SORTS
I have a multi-page workbook. The first page containes the master client data
in 5 columns. The other 12 pages (one for each month) containes both the master data (transfered using the following formula; =IF('MASTER LIST'!B3<"",'MASTER LIST'!B3,"") ). There are then additional columns where data is entered for each client. When a new client is added to the master list at the bottom and then alpha sorted. While the master data sorts on the other pages, the entered data does not follow the client. How can this be repaired? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum by different sorts | Excel Discussion (Misc queries) | |||
Macro sorts | Excel Discussion (Misc queries) | |||
Sorts | Excel Worksheet Functions | |||
A question of sorts | Excel Discussion (Misc queries) | |||
Macro that sorts | Excel Worksheet Functions |