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

Create a dynamic master file 1
Treating multiple paragraphs as one 2
Syncing between source worksheet and dependent worksheets 0
Link to another workbook path issue 1
Sharing Excel 365 Mac<->PC 0
Linked cells limited to ~253 characters unless source file open 3
sort source data sheet while destination shows same data 1
Excel-how to link source workbook to copy of destination workbook 1

Top