Summary of all Sheets

[rizmomin]

Hello:

Please refer to attached sheet.

I have excel workbook with data for each month.
I need a VB Macro to copy all the data from each month from Cell B4 to end of data into "Summary" Sheet.

In Summary sheet column A would need to be the name of the month the data is from.

I have manually copied 2 months of data in Summary Sheet.
Please see the name of the month in column A and this is how i need it.

Please let me know if any questions.

Thank you

Riz Momin

[bigroo1958]

SummarizeTabs.xlsmRizMomin,

I am new to VBA and learning a lot from the members of this site.
Please review the attached spreadsheet, the vba does what you want but I am not too sure how to add the sheet name the data is coming from into the summary tab, sorry.
I would be interested in how to do this myself! I am sure you will see someone come up with the answer from here.

Thanks

[AB33]

Hi Riz,
I can not attach the sample as it is too big.
Try this on your actual and will adjust if necessary.

Please Login or Register  to view this content.

[rizmomin]

Hi AB33:

The code seems to work except the date in column A of Summary sheet.
The date it shows is 1/11/2013, 2/11/2013,3/11/2013, and so on.
Since the name of the monthly tab is Jan11,Feb11,Mar11, and so on, the date in column A of Summary sheet needs to be 1/1/2011,2/1/2011, and so on.
IF monthly sheet names are Jan12,Feb12, and so on then the date in column A of summary sheet would need to be 1/1/2012, 2/1/2012, and so on.

Please let me know if any questions.

Thank you

Riz Momin

[AB33]

Hi Riz,
Add this line below or above the formatting line with number
ms.Range("D2:K" & Rows.Count ).NumberFormat = "#,###0.00"

Please Login or Register  to view this content.

[rizmomin]

Hi AB33:

I have added the above line of code and now it is giving result as 11/01/2013 for Jan11 sheet, 11/02/103 for Feb11 sheet and so on.

Please have a look and let me know.

Thank you

Riz Momin