A weekly file is created with a scoring method for colleagues
I then had a monthly master file that by referencing the months “week numbers” the data from the required 4 or 5 workbooks could be combined for a months’ total (and a copy saved called that month)
This worked perfectly with Excel 2007 and INDIRECT.EXT function from MOREFUNC
Having had to move to excel 2016 this is the one major loss have I have encountered
Can anyone suggest an alternative method
Formula was
Please Login or Register to view this content.
C3 = p:\my Documents\driver database\driver assessment 2016\ (Path)
D3 = DRIVER ASSESSMENT WK_27.xlsm ‘This is the variable’ (Workbook Name)
I3 = SCALESHEET (Worksheet Name)
Scale = named range
Drivername = named range
Score = named range
Title = named range
Any help appreciated
Bookmarks