Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching worksheet and exporting name to other sheet
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exporting into a Worksheet | Excel Discussion (Misc queries) | |||
Need help searching another sheet and retrieving a value | Excel Worksheet Functions | |||
Automatically exporting data to a second sheet | Excel Discussion (Misc queries) | |||
searching a protected sheet | Excel Discussion (Misc queries) | |||
Exporting .xls sheet | Excel Discussion (Misc queries) |