Filter, Split And Move Data For Each Month From Master Workbook To Individual Sheet

[vivek09]

Hi,

Need someone help on creating a MACRO for the attached excel sheet, Data in file contains three month data of 2010.


Every Month first day i need to pull the last month data in to one new excel. For eg. If current month is May, then i need to pull previous month (April) data in to one new excel.

Now My need is, I need a macro where i need to enter the certain month in the dialog box and that file need to pull thay month data into new excel sheet.

Can anyone help me on this.



Many Thanks In Advance,