Macro !

[fi.or.jp.de]

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

 

[Gord Dibben]

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

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


Gord Dibben MS Excel MVP