K. Georgiadis
04-13-2007, 11:12 AM
I am not optimistic about the feasibility of this, but let me try anyway:
1) I have a large workbook (20 megs) with sales data for 2003, 2004 and 2005.
2) For each year there are two worksheets: one sorted by distributor, the other sorted by product. Total 6 worksheets
3) In each sorted worksheet, I have inserted subtotals using Excel's built-in Data>Subtotals function
4) For further analysis, I want to transfer the subtotals ONLY to a brand new workbook, which should be more manageable in size. This is all the more important because the final analysis will have to be disseminated to various people as an email attachment. Even when zipped, the original file exceeds the size allowed by most ISPs.
Can the creation of the new workbook with Subtotals only be automated with VBA?
1) I have a large workbook (20 megs) with sales data for 2003, 2004 and 2005.
2) For each year there are two worksheets: one sorted by distributor, the other sorted by product. Total 6 worksheets
3) In each sorted worksheet, I have inserted subtotals using Excel's built-in Data>Subtotals function
4) For further analysis, I want to transfer the subtotals ONLY to a brand new workbook, which should be more manageable in size. This is all the more important because the final analysis will have to be disseminated to various people as an email attachment. Even when zipped, the original file exceeds the size allowed by most ISPs.
Can the creation of the new workbook with Subtotals only be automated with VBA?