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

The Tueday prior to a holiday... 8
Countif between Time stamps and have - value 0
Line charting the same series using data from multiple sheets? 1
Unhide column difficulty 3
Attn: Luke - followup to the 4 IF's from Friday 10
Data selection from one worksheet into a second worksheet. 1
Simple Copy to and From Cells With IF statement. 3
Average Times by Possible Named Ranges 3

Top