| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Search formula
I am looking for a formula to accomplish the following:
I want to search column A of a worksheet for a specific trxt string. If that string is found I want to copy the data from that same row to a second worksheet. For example I am looking for "Widgets" in column A of Worksheet1. When it finds "Widgets" in cell A250 I want Excel to copy and paste cells B250, C250, D250, etc. into worksheet2. Does anyone know if there is an easy way to do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
| Search column and move text formula | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
| Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions | |||
| How do I use Range Names listed in a VLookup table in a formula? | Excel Worksheet Functions | |||
Threaded Mode
