Need assistance with a google sheets formula (incrementing issue)-CodePudding

I'm using this formula to ref from one google sheet to another. =IMPORTRANGE("https://docs.google.com/spreadsheets/d/1HKmUMM4vLvNt9Z20Yc_VyrDx25MxlDQlJjTAXtHl-p4/edit#gid=397776635", "012!D1")

I need the part that says 012 to increment, but I need the D1 part to stay the same. Any suggestions?

TIA

=IMPORTRANGE("https://docs.google.com/spreadsheets/d/1HKmUMM4vLvNt9Z20Yc_VyrDx25MxlDQlJjTAXtHl-p4/edit#gid=397776635", "012!D1")

CodePudding user response：

To import all of column D, specify D1:D, like this:

=importrange("1HKmUMM4vLvNt9Z20Yc_VyrDx25MxlDQlJjTAXtHl-p4", "012!D1:D")

To import the first 100 rows, specify D1:D100:

=importrange("1HKmUMM4vLvNt9Z20Yc_VyrDx25MxlDQlJjTAXtHl-p4", "012!D1:D100")

CodePudding user response：

Is "012" the name of the sheet? You can do something like this:

=BYROW(INDEX(text(sequence(20,1,12,1),"000")),LAMBDA(each,Importrange("1HKmUMM4vLvNt9Z20Yc_VyrDx25MxlDQlJjTAXtHl-p4",each&"!D1")))

Change BYROW with BYCOL if you want it horizontally. Change 20 with the amount of sheets you need to grab and 12 to your first sheet (I've put 12 because it was your example).

PS: It works when you only import one cell