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

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