MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Copy a cell intake

Posted by Tezza on February 08, 2002 4:08 PM

How do I copy a cell from one to the next, or even more importantly from one sheet to the next, without Excel trying to be clever and adding onto row numbers/column numbers/ sheet names! etc.


Posted by Derek on February 09, 2002 7:09 AM

See Help re absolute and relative referencing. You need to use the $ sign before the column and row (eg A1 becomes $A$1). Whichever part is preceded by $ (column, row or both) remains fixed when you scroll.
Hope this helps