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.