sort source workbook data, maintain formulas in destination workb.

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link changes in destination workbook 4
Excel-how to link source workbook to copy of destination workbook 1
copied formulas refer to destination sheet not source sheet 2
sort source data sheet while destination shows same data 1
how can i update links in destination workbook when source workbo. 1
Multiple "source" workbooks linked to single "destination" workboo 1
Linked cells limited to ~253 characters unless source file open 3
linking workbooks when source data moves 1

Top