Originally Posted by
TMS
G2:
copied across and down.
That assumes you make the dates into true dates and format them as described. You also need to make the user IDs consistent.
See the updated example.
Regards, TMS
That works perfectly !!!
Thanks TMS
Quick Question though ... due to this being related to team members and the managers which can change at anytime I was wondering if it was possible to do the following .....
The file is laid out in format of Column A being the Managers name and B being the Staff Members name rather than the formula itself containing the managers name to the relevant tab could this be fetched from the cell in column A ?
So as above instead of Manager1 it could say A2 which would contain the managers name which is an exact copy of the tab names
So at least then if Managers or Team Members do change this can be updated within Column A and / or B which would automatically update the vlookup value in the formula ?
Thanks
Dave
Bookmarks