knobcreekfan
New member
Is it possible to have a dynamic file and tab reference within a formula?
Here is what I am trying to do...I have a new client that has a couple dozen facilities. Each facility has 10-12 crews. Each crew has 8-10 people. All of their pay is based on their units produced. So, I have a separate file for each facility and a separate tab within those files for each crew to compute their weekly pay.
Now I need to create an excel file that can be used to import this data into an outsourced payroll service. They have a very specific format they require so I cannot just use the spreadsheets as is from above. My intent is to simply look to the appropriate cells in each file & tab.
And that is what I am trying to make easier. I do not want to go into this spreadsheet and physically point each cell to the appropriate file & tab.
If I have a pretty simple lookup that says facility A = Phoenix, B = Tempe, C = Tucson, etc..., is it possible to have the normal =[Book1]Sheet1!A1 pickup a different file & tab based on those lookups?
Thank you.
Here is what I am trying to do...I have a new client that has a couple dozen facilities. Each facility has 10-12 crews. Each crew has 8-10 people. All of their pay is based on their units produced. So, I have a separate file for each facility and a separate tab within those files for each crew to compute their weekly pay.
Now I need to create an excel file that can be used to import this data into an outsourced payroll service. They have a very specific format they require so I cannot just use the spreadsheets as is from above. My intent is to simply look to the appropriate cells in each file & tab.
And that is what I am trying to make easier. I do not want to go into this spreadsheet and physically point each cell to the appropriate file & tab.
If I have a pretty simple lookup that says facility A = Phoenix, B = Tempe, C = Tucson, etc..., is it possible to have the normal =[Book1]Sheet1!A1 pickup a different file & tab based on those lookups?
Thank you.