| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Copying cells with similar column values
I have two worksheets in a spreadsheet with similar values in Sheet 1 Column
A and Sheet 2 Column A. I would like to create macro that would match like values in column A in both sheets and copy the entire row in Sheet B to Sheet A. I have provided an example below: Befo Sheet 1 A B C D E 250 mE 1 300 YOU 2 360 ME 3 Sheet 2 A B C 250 Good 2905 300 Bad 1605 360 Good 5000 After Sheet 1 A B C D E F 250 Me 1 250 Good 2905 300 You 2 300 Bad 1605 Many thanks in advance -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200605/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| Copying values but skipping empty cells | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| How sum values in column B using values in column A as the conditi | Excel Worksheet Functions | |||
Threaded Mode
