VBA Macro to calculate values in cell(s) from multiple sheets

[Closed]
Report
Posts
14
Registration date
Tuesday October 30, 2012
Status
Member
Last seen
January 5, 2017
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
Greetings to the greatest trouble shooting team we have around,

I am stuck in a situation where I have multiple sheets in a workbook, say this workbook contains information/details of every day for a month.

- Sheet name appears as - 368_14_11, 369_15_11, etc.. [batchId_Date_Month]
- On these sheets we have values [digits] from Cell C30:G34.

Requirement -
- We need to create a [Summary] sheet in this workbook.
- Sum the values of Cells C30:G33 [individually].
- Paste them on the same cell range i.e. [C30:G33] in a [Summary] sheet.

Note: We can remain following the labels as it is on [Summary] sheet as well.
Cell B29
Cell B30
Cell B31
Cell B32
Cell B33

An immediate assistance in the above request would be highly appreciated.

Thank you and Best Regards - ajaydwivediji

1 reply

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
41
Hi ajaydwivediji,

I would like to assist you here. If your sheet does not contain any confidential data, please upload the sheet to the below mentioned website and provide me the link to download. I will rework the sheet and will post back the link to download the sheet with calculated fields.

SpeedyShare.com

Waiting to hear from you.