Skip to main content
Web Applications

Return to Question

added 7 characters in body; edited tags; edited title
Source Link
user0
user0
  • 27.1k
  • 10
  • 53
  • 78

Google Sheet - Combining 33x IMPORTRANGE with dynamic range

I have 3 Google Sheet and want to combine all of them with:

  • Sheet 1: 480 rows
  • Sheet 2: 40 rows
  • Sheet 3: 20 rows

The sheet keeps expanding by the day, since the sheet's data comes from a Google Form

Currently I have the formula:

={IMPORTRANGE("Sheet 1 Link","Response!A2:M480");
  IMPORTRANGE("Sheet 2 Link","Response!A2:M40");
  IMPORTRANGE("Sheet 3 Link","Response!A2:M20")}

And I need to update the range of each sheet whenever there's new rows of data I need to manually update it into:

={IMPORTRANGE("Sheet 1 Link","Response!A2:M481");
  IMPORTRANGE("Sheet 2 Link","Response!A2:M42");
  IMPORTRANGE("Sheet 3 Link","Response!A2:M23")}

Is there any way to make the IMPORTRANGE's range dynamic depending on Response sheet's current row?

Google Sheet - Combining 3 IMPORTRANGE with dynamic range

I have 3 Google Sheet and want to combine all of them with:

  • Sheet 1: 480 rows
  • Sheet 2: 40 rows
  • Sheet 3: 20 rows

The sheet keeps expanding by the day, since the sheet's data comes from a Google Form

Currently I have the formula:

={IMPORTRANGE("Sheet 1 Link","Response!A2:M480");
IMPORTRANGE("Sheet 2 Link","Response!A2:M40");
IMPORTRANGE("Sheet 3 Link","Response!A2:M20")}

And I need to update the range of each sheet whenever there's new rows of data I need to manually update it into:

={IMPORTRANGE("Sheet 1 Link","Response!A2:M481");
IMPORTRANGE("Sheet 2 Link","Response!A2:M42");
IMPORTRANGE("Sheet 3 Link","Response!A2:M23")}

Is there any way to make the IMPORTRANGE's range dynamic depending on Response sheet's current row?

Combining 3x IMPORTRANGE with dynamic range

I have 3 Google Sheet and want to combine all of them with:

  • Sheet 1: 480 rows
  • Sheet 2: 40 rows
  • Sheet 3: 20 rows

The sheet keeps expanding by the day since the sheet's data comes from a Google Form

Currently I have the formula:

={IMPORTRANGE("Sheet 1 Link","Response!A2:M480");
  IMPORTRANGE("Sheet 2 Link","Response!A2:M40");
  IMPORTRANGE("Sheet 3 Link","Response!A2:M20")}

And I need to update the range of each sheet whenever there's new rows of data I need to manually update it into:

={IMPORTRANGE("Sheet 1 Link","Response!A2:M481");
  IMPORTRANGE("Sheet 2 Link","Response!A2:M42");
  IMPORTRANGE("Sheet 3 Link","Response!A2:M23")}

Is there any way to make the IMPORTRANGE's range dynamic depending on Response sheet's current row?

Source Link
Kerzoz
Kerzoz
  • 113
  • 2

Google Sheet - Combining 3 IMPORTRANGE with dynamic range

I have 3 Google Sheet and want to combine all of them with:

  • Sheet 1: 480 rows
  • Sheet 2: 40 rows
  • Sheet 3: 20 rows

The sheet keeps expanding by the day, since the sheet's data comes from a Google Form

Currently I have the formula:

={IMPORTRANGE("Sheet 1 Link","Response!A2:M480");
IMPORTRANGE("Sheet 2 Link","Response!A2:M40");
IMPORTRANGE("Sheet 3 Link","Response!A2:M20")}

And I need to update the range of each sheet whenever there's new rows of data I need to manually update it into:

={IMPORTRANGE("Sheet 1 Link","Response!A2:M481");
IMPORTRANGE("Sheet 2 Link","Response!A2:M42");
IMPORTRANGE("Sheet 3 Link","Response!A2:M23")}

Is there any way to make the IMPORTRANGE's range dynamic depending on Response sheet's current row?