Pasting Data to specific worksheet based on a value

[theDoc]

I am tring to create a vba button to paste monthly data to a specific worksheet say "Jan" or "Feb"

I have data on a worksheet where in Cell C:15 there is always the month (Eg "January 2011") the data represents. I need to move this data to a specific sheet in the same workbook named "Jan".

Thanks for help

 

[theDoc]

Here is an example: Since the data is for ''January 2011" I need this data copied and pasted to sheet named "Jan".



Jan-11 Rep Stats

Rep Name Type Data1 Data2 Data3 Data4 Data5
Smith , Thomas G 1.00% 1.00% 1.00% 1 1
Klein, Marc G 1 15.00% 13.89% N/A 5.45
williams, Kennito G 1.00% 11.00% 7.32% N/A 6.94

 

[theDoc]

Also the "Jan" sheet already exists. as do "Feb" "Mar"...etc,.

I manipulate the data each month then send it to the proper sheet.

 

[theDoc]

The Data is imported via a .txt file into a "Drop" sheet in the workbook each month. I then use a macro to format the colums etc, but need send it to the current months sheet.