Dear Vishnu,
There is one little procedure which gives exactly the same effect as you are looking for. For this I need one blank coloumn somewhere after whatever data you have. I assume Column D is available as blank to me and I call it "Criteria". So currently Grade, Number, Copy Number and Criteria are columns A, B, C, and D respectively. Now follow the following steps:
1. Filter "Grade" for "A" or whatever criteria you choose.
2. Type "1" in the first visible cell in "Criteria"
3. Copy first visible cell of "Criteria" and select all cells below this cell in "Criteria" column and press alt+; (i.e. select visible cells only).
4. Paste the copied selection (Basically fill the visible range in "Criteria" with "1")
5. Clear the filter
6. Copy Range B:B
7. Paste on Range E:E (Additional column after "Criteria")
8. Apply filter on "Criteria" for "Blanks", and delete all visible cells in Range E:E
9. Remove Filter and copy Range E:E
10. Select Range C:C and Paste Special (Formulas or Values as you like)+ Skip Blanks.
11. Delete Range D:E
12. Filter "Grade" for "A" or whatever criteria you choose.


Even though the process looks a bit long, applying it takes less than a minute once you get used to.
Hope it helps.

Anil Saini.


Quote Originally Posted by hifliers View Post
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