Help with 'Import Range' of selection of columns with google spreadsheets?
Bouncer5
Posts: 615 Forum Member
✭✭
Hi all,
I have successfully linked to a google spreadsheet and managed to de-select the top few rows using the following syntax:
=IMPORTRANGE"URL"Worksheet!A5:H41")
This essentially cuts out rows 1-4 starting on A5 and capturing a square of data down to H41. From here I need to only include j5:k41, m5:n41, p5:q41, etc. (excluding columns I, L, O, etc. and always going from row 5 down).
Can anyone advise on how to extend the formula? I can do it in little chunks by having multiple formulas but would rather do it in one line if possible.
I then need to do this with 26 other worksheets but they all have the same structure, with different worksheet names so I guess I could simply create the additional worksheets, copy the syntax but rename the reference to the worksheet accordingly....
Any help much appreciated as always!!!!
I have successfully linked to a google spreadsheet and managed to de-select the top few rows using the following syntax:
=IMPORTRANGE"URL"Worksheet!A5:H41")
This essentially cuts out rows 1-4 starting on A5 and capturing a square of data down to H41. From here I need to only include j5:k41, m5:n41, p5:q41, etc. (excluding columns I, L, O, etc. and always going from row 5 down).
Can anyone advise on how to extend the formula? I can do it in little chunks by having multiple formulas but would rather do it in one line if possible.
I then need to do this with 26 other worksheets but they all have the same structure, with different worksheet names so I guess I could simply create the additional worksheets, copy the syntax but rename the reference to the worksheet accordingly....
Any help much appreciated as always!!!!
0