0

How do you copy "sheet1, column a" onto "sheet2" without using cut and paste?

I have tried using a basic =sheet1!A1 formula, and this almost works; however, I have to add and remove data from "sheet1, column a", and as a result, on "sheet 2", the cell only references the cell originally at A1 and changes up and down depending on where I've added columns or rows to sheet1. It won't automatically add the new data onto "sheet2' unless I re-cut and paste the column.

For example, if I add a column to the left of the data in column A on sheet1, the formula on sheet2 will automatically update to =sheet1!B1. I want the formula to still refer to the cell A1 though. How can I accomplish this?

Any help would be appreciated.

1 Answer 1

3

You can use the following function for a cell to keep its reference even when the target is moved:

=INDIRECT("sheet1!a1")
1
  • You got it! Deleted my answer cause you were right!
    – Damon
    Aug 3, 2013 at 16:53

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .