beekerdale
New Member
- Joined
- Oct 7, 2019
- Messages
- 9
This formula works good for me for referencing another sheet, but I am looking to increase the size of the sheet to the right,
And so-I am wanting this formula to to reference R100, R101, R102, R103, R104 "and so on" as I drag it to the right.
Any suggestions?
=arrayformula((IMPORTRANGE("1mRD1xdG5YWOeYPJXPrc6xvuMgha54sbtiV-5imIdbC4","TimeSheet!r100")))
And so-I am wanting this formula to to reference R100, R101, R102, R103, R104 "and so on" as I drag it to the right.
Any suggestions?
=arrayformula((IMPORTRANGE("1mRD1xdG5YWOeYPJXPrc6xvuMgha54sbtiV-5imIdbC4","TimeSheet!r100")))