How to use VBA Code as a template for new monthly spreadsheets?

[sunwave]

Is there a way to use VBA code as a template for new data sheets that I receive every month? The VBA code is supposed to act as a tool for new monthly data with the same columns, same content. How do I turn my code into a template for new data? Is there a way?

 

[JerrExcel]

Hi,
Are you still looking for a solution?
Please share more on you monthly data. Can you provide an example of the new data every month? What you intent to do with the data?


For a start,
My current job is using VBA template as monthly reports. Here is how I did it:
Step 1: In template, create a sheet for "Raw Data"
Step 2: Create a sheet for any "Analysis" or "Statistics" on the "Raw Data"
Step 3: Create a sheet "Dashboard", with buttons of macros

1. Button 1: Reset template. Use VBA to clear last month data in "Raw Data" & "Analysis"
2. Button 2: Open filedialog, let user to choose the new data sheets for the current month, copy everything into "Raw Data" (as you said, same columns, same content)
3. Button 3: Transform data (do whatever you wanted to analyze the data) in "Analysis"
4. Button 4: Export sheet "Raw Data" & "Analysis" into new workbook, save as monthly report, auto-name the workbook as new month, and auto save it into a designated folder.

You may start from these step, then look for macro solutions for each step.

Thanks!