Need Macro to autofilter and copy data and paste in new file

[suyogpatil]

Hi All,

I am quite new to VBA coding and need your help to create this macro.

so here is quick description ( i have also attached file for better understanding if i am not able to explain properly)

So basically i have a database where i have details of members so i need a macro which will first auto filter on column G i.e : "TL Name" then it will select one TL name which i will provide and will copy the data and will paste in another new excel file and it will rename that new file with that TL name.

e.g. In the attached file in sheet 1 i have created drop down list so i will select first name in the list i.e Praveen kumar B and will click on "Run Macro" button. Once i click that button i need macro to copy the data only for praveen kumar B(filter should be on column G "TL name" and should copy all the rows related to praveen kumar B" ) Once its done then it should create new file and copy that data in that new excel file and rename it with the name i have selected like here praveen kumar B and save and close.

This process i need to do every week and its very hectic it will be very helpful if you could help me in this as after there are some other stuff also but i created macro for that but above coding is very tough for me ... Thanks in advance