Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sorting worksheets containing both imported data and user entered
I have a workbook with a "master client" sheet containing basic data in 5
colums(first name,last name, ID#, date and funding source) I then have 12 sheets (one for each month) where that information is copied using the formula: =IF('MASTER LIST'!B3<"",'MASTER LIST'!B3,"") for each cell, with 5 columns to the right where numrical data is entered. PROBLEM: When new clients are entered on the master sheet and alpha sorted, while the client info on the other 12 sheets is alpha correct, the coresponding data entered does not follow the client. How can I be sure data follows the new sort? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting imported data | Excel Worksheet Functions | |||
How can Excel user preferences be imported from an existing PC? | Setting up and Configuration of Excel | |||
sorting on imported Data Excel 2007 | Excel Discussion (Misc queries) | |||
sorting through unknown source data as it is entered | Excel Worksheet Functions | |||
Sorting imported .txt data in Excel | Excel Worksheet Functions |