I am trying to dynamically import data from another Google sheet (sheet2), to current Google sheet (sheet 1).
In sheet 1, I would like to input the starting cell
A2 and ending cell
D20 in cells
B3, then use
IMPORTRANGE to do that:
=IMPORTRANGE("url", "Training! INDIRECT("B2"):INDIRECT("B3")")
but it gave me a "formula parse error" message. Any help is highly appreciated.