Need help copy/pasting functions in cells

MGreenPKWY

Hello everyone. I know there is a way to do this but for the life of me, I cannot recall how to make this happen.

I am currently creating a sheet that gathers data from cells in other sheets, while using the =index function. Example: =INDEX({SPT - Order Form (rev01/23) Range 21}, 1, 0)

Instead of typing the formula, clicking into the referenced sheet, adding 1,0 behind it, how can I make the formula so that when I copy and paste it, it brings back the rows under the initial cell?

As of right now, if I copy and paste the formula into the cells beneath it, it is grabbing the same info but when I click into it and change the referenced cell, it changes the cell I copied and pasted from.

I hope I am explaining this well lol

Paul Newcome

You do not want to "Edit Reference". You would need to highlight the entire cross sheet reference so that the link text in the helper box changes to "Reference Another Sheet" and create a enw cross sheet reference.

Paul Newcome

You do not want to "Edit Reference". You would need to highlight the entire cross sheet reference so that the link text in the helper box changes to "Reference Another Sheet" and create a enw cross sheet reference.

MGreenPKWY

Thanks Paul! That's pretty much what I discovered and it worked out. Thanks for answering!

Paul Newcome

Happy to help. 👍️