Cell Reference locking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to lock a cell reference from one sheet to another.
i.e.
Cell A1 on "sheet 1" needs to ALWAYS be referenced by cell D5 on "sheet
2."

I have tried using $ signs and using the sheet protection to no avail.
What happens is when ever a user moves the information via drag and drop or
copy and paste (other than copying and pasting up in the tool bar) the cell
reference moves with it.
i.e.
User highlights the cell B1 on "sheet 1" and drags it to cell A1.

On my machine what happens is that Cell D5 is now referencing B1 and the
cell that was referencing B1 now indicates #REF.

Anyone know how to keep a point of reference regardless of the method used
to copy info?
 

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

Code to format cells on several worksheets 2
SUMIF function and cell /sheet reference 3
protect cell format 1
fill reference to cells in a row down a column 3
Referencing a cell even if its contents are moved moved/replaced 6
modify all formula references in multiple cells 3
How do I anchor a cell reference? 3
Blank Cell Reference, without if statement 4

Back
Top