beekerdale
New Member
- Joined
- Oct 7, 2019
- Messages
- 9
I have over a hundred paystubs that reference many timesheets. As I give the employees a new timesheet at the start of the new year I need to Find & Replace hundreds of sheets at once. I would like to add a master sheet to just update the URL Code on the new mastersheet and then this will allow the paystubs to all pull off of the new sheets
This is the current formula that I use:
=arrayformula((IMPORTRANGE("18jpHh3RFOiU6tiOdeLfI7ZAQOsCK-pbwm1TmSl_AihE","TimeSheet!aj58")))
I was thinking something like this would be ideal, but it is not working:
=arrayformula((IMPORTRANGE(""1p9jCwTmlO-2sMbYEH0OukDqm45mUwOSN0WwZHr1DpH0",sheet1!c6""TimeSheet!aj57")))")))"
So, in a nutshell. - how can I get the "18j...." formula to pull from a separate sheet that will contain all the master URL's that I will manually input as I create the new timesheet.
Basically I want to use the URL code from one sheet and a "sheet1!c6:" from another sheet.
I hope this makes sense, Any help would be great,
Thanks,
Dale
This is the current formula that I use:
=arrayformula((IMPORTRANGE("18jpHh3RFOiU6tiOdeLfI7ZAQOsCK-pbwm1TmSl_AihE","TimeSheet!aj58")))
I was thinking something like this would be ideal, but it is not working:
=arrayformula((IMPORTRANGE(""1p9jCwTmlO-2sMbYEH0OukDqm45mUwOSN0WwZHr1DpH0",sheet1!c6""TimeSheet!aj57")))")))"
So, in a nutshell. - how can I get the "18j...." formula to pull from a separate sheet that will contain all the master URL's that I will manually input as I create the new timesheet.
Basically I want to use the URL code from one sheet and a "sheet1!c6:" from another sheet.
I hope this makes sense, Any help would be great,
Thanks,
Dale