Cross sheet reference multiple cells by dragging
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!
Comments
-
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
-
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.
-
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.
-
Thank you! This was very helpful!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!