Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Column range to search from a source workbook and then copy/paste
I am trying to use a range in my current worksheet containing all of column A
which may have multiple copies of the same data in many rows to search a source list on a sheet in another workbook and then copy the source row connected to the data in column A only once to the bottom of the current sheet for each different data type. Does anyone have a good solution. Current Sheet Example A B C D E F G H 1 Apple Red 2 Apple Green 3 Pear Green 4 Banana Yellow 5 Banana Green 6 Grapes Purple 7 Grapes Green 8 Grapes Red Source Sheet in another workbook A B C D E F G H 1 Apple xxx yyy 2 Pear xxx yyy 3 Banana xxx yyy 4 Grapes xxx yyy 5 Strawberries xxx yyy 6 Kiwi xxx yyy New Sheet A B C D E F G H 1 Apple Red Round 2 Apple Green 3 Pear Green 4 Banana Yellow 5 Banana Green 6 Grapes Purple 7 Grapes Green 8 Grapes Red 9 Apple xxx yyy 10 Pear xxx yyy 11 Banana xxx yyy 12 Grapes xxx yyy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
select and copy 100 random cells from a range in a source workbook | Excel Worksheet Functions | |||
Looping: Search Range in Multiple Selected Worksheets, Copy/Paste | Excel Programming | |||
Search within range for first populated cell and copy to new workbook | Excel Programming | |||
Need a macro to copy a range in one workbook and paste into another workbook | Excel Programming | |||
Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming |