Replace Filtered Value

[minmin]

Hi,

I need to seek assistance in regard to AutoFilter.

First, I need to filter Code "A", "B", "C". If code "A" is filtered and my row = 3 I will replace

the value into COFFEE, TEE, CHOCOLATE. And if code "B" is filtered and my row=2 then I will replace

the value into COFFEE, TEE and lastly if code "C" filtered and my row =1 I will replace the value

into COFFEE.

Scenario:

Code Value CRITERIA
A 10 COFFEE
B 20 TEA
C 30 CHOCOLATE
A 40
B 50
A 60

OUTPUT:
Code Value
A COFFEE
B TEA
C CHOCOLATE
A COFFEE
B TEA
A COFFEE


I started my code with this but I was stacked in here. I Hope someone will help me with my code.

Please Login or Register  to view this content.

Thank you so much.

[JasperD]

So basically, if the cell in column A says "A" then you want the cell in column C to say "COFFEE", when the cell in column A says "B", you want the cell in column C saying "TEA" etc ?

Why not just like this :

Please Login or Register  to view this content.

Please click the * below if this helps

[minmin]

Hi thank you so much for your quick reply.

I think my output was misleading. My output should look like this:

If A was filtered:
OUTPUT:
Code Value
A COFFEE
A TEA
A CHOCOLATE

If B was filtered:
OUTPUT:
Code Value
B COFFEE
B TEA


If C was filtered
OUTPUT:
Code Value
C COFFEE

If you notice If no. of rows is 3 then then output should be COFFEE,TEA,CHOCOLATE
If no. of rows is 2 then output should be COFFEE,TEA
If no. of rows is 1 then output should be COFFEE

The maximum of rows is only three.

I hope you can help me. Again thank you