| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sort source workbook data, maintain formulas in destination workb.
I am setting up a workbook that has cell formulas linked to data in 2 other
workbooks. I want to know if there is a way that I can sort the data in the 2 source workbooks while maintaining the correct linked cell formulas in the destination workbook? (when I sort the data in the source workbooks it does not update the new cell formulas in the destination workbook and therefore pulls the wrong data) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sort source workbook data, maintain formulas in destination workb.
Did you try making your formulas absolute?
"jfb191" wrote: I am setting up a workbook that has cell formulas linked to data in 2 other workbooks. I want to know if there is a way that I can sort the data in the 2 source workbooks while maintaining the correct linked cell formulas in the destination workbook? (when I sort the data in the source workbooks it does not update the new cell formulas in the destination workbook and therefore pulls the wrong data) |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sort source workbook data, maintain formulas in destination wo
No I didn't. How do I go about doing that? Thanks for your response!
"Difficult1" wrote: Did you try making your formulas absolute? "jfb191" wrote: I am setting up a workbook that has cell formulas linked to data in 2 other workbooks. I want to know if there is a way that I can sort the data in the 2 source workbooks while maintaining the correct linked cell formulas in the destination workbook? (when I sort the data in the source workbooks it does not update the new cell formulas in the destination workbook and therefore pulls the wrong data) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing unopened worksheet into an open Workbook | Excel Discussion (Misc queries) | |||
| Automatically pasting worksheet data to new worksheet with formulas | Excel Worksheet Functions | |||
| Reference multiple cells in if statement | Excel Worksheet Functions | |||
| Updating master workbook from source that may/may not exist | Excel Worksheet Functions | |||
| sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
Hybrid Mode
