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