How to create link of DATA not cell reference in Excel?

N

NineuhtOK

Here Goes...long story short, I am trying to make Excel work a little like
Access. I have a 'main' worksheet with data. Additional worksheets/tabs
have links of the data on the 'main' tab.

However...when I delete or add a row, or resort the data on the 'main' tab,
the linked data continues to reference the ROW/COLUMN instead of the DATA and
the links are therefore useless to me.

Can a formula be used where the DATA is linked rather than the R/C, so that
when the 'main' worksheet/tab is updated, the linked worksheets are updated
correctly?

Thanks for your suggestions!
 

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

Embed the same Excel multiple times 0
Linking data in MS Word into Excel 5
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Cells not updated automatically 3
linking two worksheets in the same workbook 3
Possible to refer to a sheet's object name ? 1
How Do I Avoid #REF! In Formulas? 5
How 2 Link DATA instead of CELL REFERENCE - Pulling My Hair Out! 6

Top