Linking cells between sheets

J

John

Example: Sheet1 has master data which is linked to various other 'working'
sheets in the same workbook. In practice, the master data has to be moved
around regularly, using cut and paste. Each time this happens, Excel moves
the reference in the 'working' sheet, which is not what is required.
All I want to do (for example) is make sure that cell A8 in the working
sheet ALWAYS equals cell A2 in the master sheet - even if I have cut and
pasted the data in A2 on the master sheet to another location. I have tried
=Data!A2 and =Data!$A$2 to no avail.

Is there any way to 'lock' the referenced cell (Working A8) to the master
cell (A2).

Help much appreciated.
 

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

External cell reference between two excel worksheets both in One Drive 0
Extracting data from database into separate sheets 0
Macro to Combine Data from Multiple Sheets with Cell References 4
Macro to Format Multiple Sheets based on "Master" Format 0
How do you make a summary sheet? 0
Excel linking from one master worksheet to many worksheets and ableto return a value back. 0
How to fill cell references from several worksheets in one? 2
Multiple column search and Copy 7

Top