| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find then copy
I'm working off of two worksheets.
Worksheet 1 contains all the data. Worksheets 2 has partial data. I need to use the data (in this case a part number) in cell A1 on worksheet 2 and find the same part number on worksheet 1 and copy the data in the adjacent three cells on worksheet 1 to the cells adjacent to the part number worksheet 2. worksheet 1 A B C D A100 x y z A200 x A300 y A400 A500 x z worksheet 2 A B C D A300 y A400 A500 x z |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to find copy "header" and paste | Excel Discussion (Misc queries) | |||
| Find text and copy and move row containing it | Excel Discussion (Misc queries) | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
| Copy Rows found using Find All feature | Excel Discussion (Misc queries) | |||
Threaded Mode
