Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

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

=INDIRECT("sheet1!a1")
share|improve this answer
    
You got it! Deleted my answer cause you were right! –  Damon Aug 3 '13 at 16:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.