D
DanS
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
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