drybsmt
New member
- Joined
- Jul 6, 2018
- Messages
- 2
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- Office365
Newbie here to the group Thanks for having and helping me!
We enter employee daily work times in a spreadsheet that calculates their hours and show their jobs for the week. We save it using filenames like this: 2018-07-01.xlsx. Next weeks will be 2018-07-08.xlsx. I would like have a worksheet included that would look up the weekly totals each employee for the previous four weeks in order to calculate holiday pay. I have researched 'Index', which will grab the data from the closed book but I can't automatically change the file name based on a formula. I would have to manually change the name in each cell. I looked at 'Indirect' which would work great but it requires the files to all be open.
Does anyone have a suggestion? Using Office365 and my skill level is intermediate. Thanks!
We enter employee daily work times in a spreadsheet that calculates their hours and show their jobs for the week. We save it using filenames like this: 2018-07-01.xlsx. Next weeks will be 2018-07-08.xlsx. I would like have a worksheet included that would look up the weekly totals each employee for the previous four weeks in order to calculate holiday pay. I have researched 'Index', which will grab the data from the closed book but I can't automatically change the file name based on a formula. I would have to manually change the name in each cell. I looked at 'Indirect' which would work great but it requires the files to all be open.
Does anyone have a suggestion? Using Office365 and my skill level is intermediate. Thanks!