Copying a Cell

[Guest]

If I copied a cell (A10) form another worksheet to B10 of my current
worksheet. If I copy B10 from my current worksheet and paste it to N10, what
symbol should I use to maintain the information from A10 insted of I10.

 

[Guest]

Back in B10 of the current worksheet there should be a formula that looks like:
=[Book1]Sheet1!$A$10
If it is missing the $ symbols, put them into it. Now no matter where you
copy that cell to, the column and row references will remain the same. This
is called absolute addressing.

If the $ in front of the column reference is not there, then the column
indicator will change as you copy left or right of the original column; if
the $ is missing in front of the row indicator then the row number will
change as you copy it into rows above or below the original location.

These rules apply to cell references within a book also. See Help on
Absolute and Relative addressing.