Pamella
07-29-2019, 02:31 AM
I have 2 sheet. One is the Source- This contains 1) ID no.s in Column B starting from Cell B3. 2) Colour in Column C and 3) The Amounts I have to retrieve are in Column E.
Then in the Output Sheet, I must paste the ID no. in column A. (in an un-used row), next paste the Amount in the same row. Row 1 in Output sheet contains all the Colours. So the macro would have to find the corresponding colour from source and match it to the one in Output and paste in the correct matching cell.
Column B which contains the Id's some contains blanks because it has multiple colours.
Source sheet would look like this
A B C D E
name ID Colour Amount Status
asda A1 Red 12
cccc 1B Red 76
ddd 2C Red 56
Blue 78
Green 532
Yellow 43
qqq 34V Yellow 566
Outputsheet would look like this...
Red Blue Green Yellow
1A 12
1B 76
2C 56 78 532 43
34V 566
Then in the Output Sheet, I must paste the ID no. in column A. (in an un-used row), next paste the Amount in the same row. Row 1 in Output sheet contains all the Colours. So the macro would have to find the corresponding colour from source and match it to the one in Output and paste in the correct matching cell.
Column B which contains the Id's some contains blanks because it has multiple colours.
Source sheet would look like this
A B C D E
name ID Colour Amount Status
asda A1 Red 12
cccc 1B Red 76
ddd 2C Red 56
Blue 78
Green 532
Yellow 43
qqq 34V Yellow 566
Outputsheet would look like this...
Red Blue Green Yellow
1A 12
1B 76
2C 56 78 532 43
34V 566