C
Charlie7805
I have tabs in a workbook for every year, 2003 to 2007. Each sheet is a list
of employees who have had an <event> during the year. Some have 2 or more
<events> in a single year.
I want to add a new sheet with a master list of all employees and insert a
lookup formula alongside each one to search each sheet returning every
<event> and the date associated with it.
A vlookup will only return one event per employee, per sheet. It will not
find multiple <events>???
Need some help please.
Thanks.
of employees who have had an <event> during the year. Some have 2 or more
<events> in a single year.
I want to add a new sheet with a master list of all employees and insert a
lookup formula alongside each one to search each sheet returning every
<event> and the date associated with it.
A vlookup will only return one event per employee, per sheet. It will not
find multiple <events>???
Need some help please.
Thanks.