Can the INDEX formula automatically update to pull the next value?

acondie

Hi,

I'm using an INDEX formula to pull a specific cell value from one sheet to the next, but I want this formula to automatically update so that every time a new cell value is added it will update on the new sheet as well. Is there a way to do this?

Right now this are the cell values I'm pulling from in Sheet 1-

To sheet 2-

Appreciate any help!

Thanks!

Melissa Yamada

Hi @acondie

I'm not sure if there is a way to add just a cell value, but you can use the Copy Row automation to add the whole row. I hope this helps!