Excel 2010 VBA - Parsing a large worksheet into smaller worksheets
I have a worksheet of cars (yes it's simple but I'm still learning this VBA stuff) and would like to:
Take each group of cars and copy it to a new sheet in the same workbook.
All chevys placed on a new sheet in the same workbook.
All Rolls placed on a new sheet in the same workbook.
All VW's placed on a new sheet in the same workbook.
See attached workbook.
cars-example-prelim.xls
Take each group of cars and copy it to a new sheet in the same workbook.
All chevys placed on a new sheet in the same workbook.
All Rolls placed on a new sheet in the same workbook.
All VW's placed on a new sheet in the same workbook.
See attached workbook.
cars-example-prelim.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you create a pivot table based upon the data, then list by model and count of sales, if you then click on the counts it will create the sheet for you.
I can do the VBA if this is important to you, but sometimes simpler is better.