Need a macro to sum range of cells
Closed
gtsellos
Posts
3
Registration date
Sunday January 27, 2013
Status
Member
Last seen
January 29, 2013
-
Jan 27, 2013 at 04:30 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 29, 2013 at 09:45 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 29, 2013 at 09:45 PM
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 27, 2013 at 10:03 AM
Jan 27, 2013 at 10:03 AM
Hello. Some additional information is needed.
A . First issue is identification of those 11 workbooks
1. These 11 workbook, are they in same folder/directory?
2. If they are in same directory, do you plan to open every *.xls* file in that directory and copy it into new workbook.
3. If there are other *.xls* files in that directory, how one can identify which 11 books to open
B. Second issue is the naming of the sheets as they get copied into new workbook. What names you would be giving to those sheets, since you cannot have more than one sheet with same name
May be if you could upload a sample files it would be more easy to see what can be done. This workbook would have the copied data into new sheet and then the total sheet. You dont need to have whole information, just sample to show how things would be. If you create a sample workbook, post it on some public file share site like speedyshare.com and post back link to the ACTUAL FILE back here.
A . First issue is identification of those 11 workbooks
1. These 11 workbook, are they in same folder/directory?
2. If they are in same directory, do you plan to open every *.xls* file in that directory and copy it into new workbook.
3. If there are other *.xls* files in that directory, how one can identify which 11 books to open
B. Second issue is the naming of the sheets as they get copied into new workbook. What names you would be giving to those sheets, since you cannot have more than one sheet with same name
May be if you could upload a sample files it would be more easy to see what can be done. This workbook would have the copied data into new sheet and then the total sheet. You dont need to have whole information, just sample to show how things would be. If you create a sample workbook, post it on some public file share site like speedyshare.com and post back link to the ACTUAL FILE back here.
gtsellos
Posts
3
Registration date
Sunday January 27, 2013
Status
Member
Last seen
January 29, 2013
Jan 28, 2013 at 12:24 PM
Jan 28, 2013 at 12:24 PM
At first, thank you very much for answering to my request.
1.the 11 workbooks are in the same folder named "statistics" and they have different name. The only same name is the name of the worksheet included "G1".
2. I shall copy the worksheets invluded into a new workbook named "master".
3. I shall rename them as "G1", "G2", 'G3" and so on.
The only thing I want to help me is to gather the sum of the range of the cells: B12...B17, C12...C17, K22...K24, and the cells D18,G18,P17 to a worksheet named "total" using a macro to do that quickly.
Thank you very much for your help. I hope that I made you understand my problem.
Is there any chance to gather all these 11worksheets into one (copy) and rename them at the same time using a command macro?
1.the 11 workbooks are in the same folder named "statistics" and they have different name. The only same name is the name of the worksheet included "G1".
2. I shall copy the worksheets invluded into a new workbook named "master".
3. I shall rename them as "G1", "G2", 'G3" and so on.
The only thing I want to help me is to gather the sum of the range of the cells: B12...B17, C12...C17, K22...K24, and the cells D18,G18,P17 to a worksheet named "total" using a macro to do that quickly.
Thank you very much for your help. I hope that I made you understand my problem.
Is there any chance to gather all these 11worksheets into one (copy) and rename them at the same time using a command macro?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 29, 2013 at 07:02 AM
Jan 29, 2013 at 07:02 AM
gtsellos : "Is there any chance to gather all these 11worksheets into one (copy) and rename them at the same time using a command macro?"
That what i thought you initially wanted/ Let macro copy the sheets into new workbook and then combine them all and hence all those questions that i asked at https://ccm.net/forum/affich-685553-need-a-macro-to-sum-range-of-cells#1
That what i thought you initially wanted/ Let macro copy the sheets into new workbook and then combine them all and hence all those questions that i asked at https://ccm.net/forum/affich-685553-need-a-macro-to-sum-range-of-cells#1
gtsellos
Posts
3
Registration date
Sunday January 27, 2013
Status
Member
Last seen
January 29, 2013
Jan 29, 2013 at 11:37 AM
Jan 29, 2013 at 11:37 AM
Can you send me this macro command?
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 29, 2013 at 09:45 PM
Jan 29, 2013 at 09:45 PM
May be if you could upload a sample files it would be more easy to see what can be done. This workbook would have the copied data into new sheet and then the total sheet. You dont need to have whole information, just sample to show how things would be. If you create a sample workbook, post it on some public file share site like speedyshare.com and post back link to the ACTUAL FILE back here.