maggie.hongmk
New Member
- Joined
- Nov 28, 2012
- Messages
- 23
I am using excel 2007.
I have several workbooks (and the NUMBER of workbooks could change), all with the same number of columns and structure showing the Income Statement of a particular business.
I would like to be able to have a SUMMARY workbook that will sum up all the workbooks that I choose to sum up in the same format. The data in each of the workbook is from column B to BI and I would like to, for example, sum all B15 numbers in the workbooks into cell B15 in the SUMMARY workbook; sum all B16 numbers in the workbooks into cell B16 in the SUMMARY workbook, and etc.
The range that I would like to sum is:
B15:BI24
B28:BI37
B41:BI50
B54:BI63
B67:BI76
B80:BI89
Is this possible? I am new to the VBA world.
Thanks
I have several workbooks (and the NUMBER of workbooks could change), all with the same number of columns and structure showing the Income Statement of a particular business.
I would like to be able to have a SUMMARY workbook that will sum up all the workbooks that I choose to sum up in the same format. The data in each of the workbook is from column B to BI and I would like to, for example, sum all B15 numbers in the workbooks into cell B15 in the SUMMARY workbook; sum all B16 numbers in the workbooks into cell B16 in the SUMMARY workbook, and etc.
The range that I would like to sum is:
B15:BI24
B28:BI37
B41:BI50
B54:BI63
B67:BI76
B80:BI89
Is this possible? I am new to the VBA world.
Thanks