how do i find data from worksheets in excel

J

James

I have 3 work sheets that contain data re a rota patten.
I have a list off 12 employees in 1 column and then 5 Columns with ranges
from Mon,Tue,Wed,Thu,Fri. I am trying to find a function that will allow me
to search for
"V" or "H" and display the name of the employee that as "V" or "H" on this
day?
Can any one help me please
J.Ainsworth
 
T

T. Valko

Can more than one employeee have a V or H for the particular day?

If the answer to that question is yes and you have the data on 3 sheets this
will be VERY difficult. Putting all the data on one sheet will make things a
whole lot easier.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting day names chronologically 5
Attn: Luke - followup to the 4 IF's from Friday 10
Line charting the same series using data from multiple sheets? 1
Sum of Daily Overtime 10
Average Times by Possible Named Ranges 2
Clearing scheduled work hours for weekends 6
Unhide column difficulty 3
Recurring pattern 2

Top