Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
Search multiple sheets, then paste results in new sheet
Hello,
I searched the web and newsgroups but couldn't find a way to do this. I would like to search multiple sheets in a particular column and paste the complete row containing the searched word into a new sheet. For example, suppose I have 2 sheets (sheet1 and sheet2), each containing 3 colums (item_number, description, brand). I would like to search for all items that are Acme brand, and have the results (complete row) pasted into a new sheet (sheet3). Anyone know how this can be done? I would truly appreciate any help with this. Best regards, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiple search results | Excel Worksheet Functions | |||
search, copy and paste through multiple sheets | Excel Discussion (Misc queries) | |||
multiple results from search / how to? | Excel Discussion (Misc queries) | |||
Copy paste WkBk/sheet 1 to multiple wkbks/sheets | Excel Programming | |||
multiple results search | Excel Programming |