sort source workbook data, maintain formulas in destination workb.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top