I
I M Desperate!!!
Here are my sheet 1 column headings:
Client #, Client Name, Location, Employee, Date
On Sheet 2, I want to show every instance where an employee did billable
work on a certain date, and show which client they were working on.
Ex: If Kevin (column d) did billable work on date x (column e), who was it
for (column b)?
Sheet 1 is constantly updated and I want sheet 2 to reflect all changes.
Thanks in advance to anyone who can assist with this issue.
Client #, Client Name, Location, Employee, Date
On Sheet 2, I want to show every instance where an employee did billable
work on a certain date, and show which client they were working on.
Ex: If Kevin (column d) did billable work on date x (column e), who was it
for (column b)?
Sheet 1 is constantly updated and I want sheet 2 to reflect all changes.
Thanks in advance to anyone who can assist with this issue.