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)

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)

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)