I am summing cells in a sheet as follows and storing them in column AH
=SUM(C2:AG2)
I am doing this for multiple rows like C3:AG3
, C4:AG4
and so on upto C51:AG51
and storing them in the respective AH row number such as AH3
, AH4
and so on.
I want to import the values in column AH
into another sheet. For this I am using the following formula
=IMPORTRANGE("sheet_url", "sheet name!AH2")
Now I want to apply the above formula for other rows like AH3, AH4 and so on.
The problem is there are hundreds of values like this and it becomes tedious to this manually.
Is there any way to automatically update the formula for multiple rows?
Thanks
EDIT1
From the above image, I want the value for AH2 in the B2, AH3 in B3, and so on.
Currently I have to do this manually by editing the formula in each cell. How do I do this automatically?
CodePudding user response:
you can just use:
=IMPORTRANGE("sheet_url", "sheet name!AH2:AH51")
OR for full range of Column AH
=IMPORTRANGE("sheet_url", "sheet name!AH2:AH")