Cross sheet reference multiple cells by dragging

Veronica GM

Hello everyone,

I would like to reference multiple cells in the same column from sheet B onto sheet A. I thought I could create a reference formula on Sheet A to pull the value from sheet B and then drag that same formula down onto the rest of the cells but noticed that the formula does not change if it is dragged. Is there a way to achieve this? (I have to pull the values from one column in Sheet B onto Sheet A and it is 1000+ cells) Please assist.

Thank you!

J. Craig Williams

Why do you need to drag the formula?

Are you trying to refer to a specific range and that range changes depending on which cell is 'asking'?

Can you post the formula you are trying to drag?

Craig

Veronica GM

Hello,

I would like to clarify and say that I am only referencing from Sheet B (sorry for the confusion, there is no formula). I need a whole column from Sheet B to be referenced onto Sheet A. I thought I could reference the first cell from Sheet B onto Sheet A and then drag that reference to the rest of the cells in the column. I attached pictures to show what I would like to accomplish. The only solution I have found so far is to reference one cell at a time.

J. Craig Williams

If you doing a sequential set of cells and only get their values, I would suggest cell linking instead of a formula. It is a simple process to select a range, copy the data, and the paste-special for links to the data.

https://help.smartsheet.com/articles/861579-cell-linking

Veronica GM

Thank you! This was very helpful!