Hello everybody,

I have many data in sheet2 there are many dates(f2:f30000)

how to make reports by month (f2:f30000) from sheet2 to new sheets?

Please can you help me to get a perfect code for this purpose? I am very new to this macro coding and need support from you.

Thanks You

• Edited by Amek.inf 4 hours 17 minutes ago

I am assuming that you mean that you want separate the data to one month on each worksheet. Is this correct?

The project should not be too difficult but would need a copy of the data to work with.

Guidelines to upload a workbook on OneDrive:

1. Zip your workbooks. Do not just save to OneDrive because the workbooks open with On-Line Excel and the limited functionality with the On-Line version causes problems.
2. To Zip a file: In Windows Explorer Right click on the selected file and select Send to -> Compressed (zipped) folder.)
3. Do not use 3rd party compression applications because I cannot unzip them. I do not clog up my computer with 3rd party apps when there are perfectly good apps supplied with windows.
4. Go to this link.  https://onedrive.live.com
5. Use the same login Id and Password that you use for this forum.
6. Select Upload in the blue bar across the top and browse to the zipped folder to be uploaded.
7. Select Open (or just double click). (Be patient and give it time to display the file after initially seeing the popup indicating it is done.)
8. Right click the file on OneDrive and select Share.
9. Do NOT fill in the form; Select "Get a Link" on the left side.
10. Click the button "Create a Link"
11. Click in the box where the link is created and it will highlight.
12. Copy the link and paste into your reply on this forum.

Hello everybody,

I have many data in sheet2 there are many dates(f2:f30000)

how to make reports by month (f2:f30000) from sheet2 to new sheets?

Please can you help me to get a perfect code for this purpose? I am very new to this macro coding and need support from you.

Thanks You

How many columns in the different Workbooks do you want to combine?

Do the columns all have the same column names (they don't have to be in the same order from left to right)?

Does the solution have to be by VBA?

Have you considered using a Pivot Table?