Macro !
 

Hi,

I have excel file
Col A Col B
Names Scores
A 20
B 30
A 40
A 50
B 60
A 70 and so on

I have applied filter, So When I use filter and selected a Name then
Macro to run.
Eg., Using filter I have selected "A" then whatever the filtered data
shown need to be copied and pasted in
separate sheet called "A".

Thanks in advance

Macro !
 

See Ron de Bruin's site for code to copy data using autofilter.

http://www.rondebruin.nl/copy5.htm


Gord Dibben MS Excel MVP

On Mon, 6 Apr 2009 20:49:47 -0700 (PDT), wrote:

Hi,

I have excel file
Col A Col B
Names Scores
A 20
B 30
A 40
A 50
B 60
A 70 and so on

I have applied filter, So When I use filter and selected a Name then
Macro to run.
Eg., Using filter I have selected "A" then whatever the filtered data
shown need to be copied and pasted in
separate sheet called "A".

Thanks in advance