linking workbooks when source data moves

J

JohnsMom

I need to be able to link two workbooks so that the source data updates the
destination workbook. The second issue is that my source data moves, as
information is added and removed, as well as sorted. Can this be done?
 
S

Spiky

I need to be able to link two workbooks so that the source data updates the
destination workbook.  The second issue is that my source data moves, as
information is added and removed, as well as sorted.  Can this be done?
Click to expand...

Use lookup formulas. VLOOKUP, INDEX/MATCH, etc.
 

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

Linked cells limited to ~253 characters unless source file open 3
Excel-how to link source workbook to copy of destination workbook 1
Multiple "source" workbooks linked to single "destination" workboo 1
Link to another workbook path issue 1
how can i update links in destination workbook when source workbo. 1
sort source data sheet while destination shows same data 1
External Links in Excel 2007 with variable source file 5
sort source workbook data, maintain formulas in destination workb. 2

Top