Hi Mates,
I have a Dashboard who needs to show the Top Ten Overtime Spenders.
This data is allocated on other file, with the following format:
='C:\Users\leandro.m.broffoni\Desktop\DWP\02- CADO Overtime Report\CADO Jun''11.xlsx]JSA Evidence Management'!AJ6
The data in red needs to change according to the date (file) and the project (sheet)
I need an formula on the overtime section that works automatically.
Attached are my file.
Bookmarks