CODEWITHSUNDEEP
urlgoogle-sheetsgoogle-sheets-formula
Smgrant4
Smgrant4

Reputation: 3

Using a cell reference, instead of a URL address in IMPORTRANGE function

I have several sheets which use the ImportRange Function. Every month, we need to change the URL to pull the data from another sheet. I was hoping to have one cell where we can enter what sheet we wish use to do all the ImportRange Functions vs manually going into each sheet and updating the URL monthly. Hope this makes sense, thank you.

Upvotes: 0

Views: 1582

Answers (1)

player0
player0

Reputation: 1

if you want cell with url/id use:

=IMPORTRANGE(A1, "Sheet1!A:C")

if you want cell with sheet too try:

=IMPORTRANGE(A1, B1)

Upvotes: 0

Related Questions