Thread
:
Searching worksheet and exporting name to other sheet
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Searching worksheet and exporting name to other sheet
You can do this with formula, macros, or a simple
datafilterautofilterfilter on daycopy rows to destination sheet. More
examples and before/after desires
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"OshawaChris" wrote in message
...
Here is the basics for the formula I need (this pertains to payroll and
attendance sheets)
My worksheet (sheet 1) looks like this.
A B
1 employee name 1 Day
2 employee name 2 Evening
3 employee name 3 Night
The function searches column B for a string (Day for day**** etc).
If the search is true, then it takes the string from colomn A in the same
row (employees name), and exports the string to a cell in a different
worksheet "sheet 2".
Any help would be greatly appreciated.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett