Dear Masters,

I have below data in my sheet with Column heading as (Grade,Number,Copy Number).

Grade Number Copy Number
A 25
B 26
B 30
A 25
A 23
B 25
B 26
A 23
A 34
C 25
C 25
A 25

I applied Autofilter gith Grade-A as selection Criteria. Now I want to copy & paste value of Number Column (relevant to A) to Copy Number Coulmn with Filter Applied. When I do using Copy & Paste it also copied value of B&C grade. Please provide the solution.

Regards,

Vishnu