Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find multiple values
I have a worksheet that contains a team of people's names of in column
A that I would like to find in another worksheet lets say an employee timesheet worksheet. Let's say the first workhsheet is called "TEAM A" and contains the names Amy, Ben, Carl, David, Earl. The other worksheet "Employee Timesheet" contains the entire list of employees that were working on a given day which may or may not include the people in "TEAM A" worksheet. I want to write a macro that would allow a user to do search for all the values in "TEAM A" that appear in appear in the "Employee Timesheet" worksheet and then take the row with the employees name (which would also include the time worked) and add that to a range that I can paste into a user specified destination. I need to know how to do the search in the "Employee Timesheet" worksheet based on the people in "Team A" worksheet. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Multiple Cell Values | Excel Discussion (Misc queries) | |||
Find a Match in Multiple Places & Return Multiple Values | Excel Worksheet Functions | |||
find values in multiple cells and paste row values | Excel Discussion (Misc queries) | |||
Find and return multiple values | Excel Worksheet Functions | |||
Find Values 0 Over Multiple Columns | Excel Programming |