Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formulas pulling from another worksheet changes when sorted
Excel spreadsheet has multiple worksheet tabs. One worksheet has formulas
that pull data from another worksheet. This works fine until you sort the data worksheet which changes the values on the formula worksheet. How can you keep the data the same and still be able to re-sort the data worksheet? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data into today's worksheet from yesterday's worksheet | Excel Discussion (Misc queries) | |||
formulas pulling data from other worksheets | Excel Discussion (Misc queries) | |||
Formulas pulling from other tables | Excel Worksheet Functions | |||
Stopping formulas from changing when sorted | Excel Worksheet Functions | |||
Do formulas in a table translate when sorted? | Excel Worksheet Functions |