Copy filtered data & paste into adjecent column with filter applied in Excel 2007

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

Dear Vasul,

I don't want use formula. With Autofilter applied I want to Copy the Data. from Column B to Column C

Is it Possible?

Vishnu

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.

Originally Posted by hifliers

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