Here is the scenario I have and I hope someone here can help.
In WORKSHEET 1 COLUMN A, I have the word DOG.
In WORKSHEET 2 COLUMN A, I have the word DOG four times.
In WORKSHEET 2 COLUMN B, I have COLLIE, GERMAN SHEPHERD, and POODLE.
What I would like to do is have EXCEL search Column A in WORKSHEET 2 for the word DOG, find all the related cells in COLUMN B WORKSHEET B, and combine them in a singe cell in COLUMN B of WORKSHEET 1.
So in COLUMN B of WORKSHEET 1, I would like to have a cell which has COLLIE, GERMAN SHEPHERD, and POODLE.
I am thinking CONCATENATE is likely to be used but is it more likely an ARRAY. Might someone know how to do this? If so, I would appreciate the help. I know how to take code and embed it into a worksheet and some basic VBA.
Thank You.
In WORKSHEET 1 COLUMN A, I have the word DOG.
In WORKSHEET 2 COLUMN A, I have the word DOG four times.
In WORKSHEET 2 COLUMN B, I have COLLIE, GERMAN SHEPHERD, and POODLE.
What I would like to do is have EXCEL search Column A in WORKSHEET 2 for the word DOG, find all the related cells in COLUMN B WORKSHEET B, and combine them in a singe cell in COLUMN B of WORKSHEET 1.
So in COLUMN B of WORKSHEET 1, I would like to have a cell which has COLLIE, GERMAN SHEPHERD, and POODLE.
I am thinking CONCATENATE is likely to be used but is it more likely an ARRAY. Might someone know how to do this? If so, I would appreciate the help. I know how to take code and embed it into a worksheet and some basic VBA.
Thank You.