Carpiem
06-29-2006, 07:46 AM
Hello,
I am hoping someone will share their expertise with filtering data by some criteria & then pasting the results to a separate sheet within the same workbook?
The attached file has 4 sheets: ?Customers?, ?Group-Codes?, ?SalesData?, ?Summary?.
?Customers? & ?Group-Codes? are provided solely to give some idea of the possible amount of data. The ?SalesData? sheet was limited to 3 Customers and 22 item Codes. Usually there would be 60 -100 Customers and 592 item Codes.
?SalesData? sheet provide sales figures for item Codes that belong to specific product Groups.
The ?Summary? sheet show total sales for the product Groups taken from the ?SalesData? sheet.
In the attached e the Customers were limited to 3 and item Codes to 22. More usually there would be 60 -100 Customers listed and 592 item Codes on the ?SalesData? sheet.
It takes an inordinate amount of time to copy each Cutomer name & Sales numbers from the ?SalesData? sheet then transpose this data onto a blank sheet? sum sales numbers? then copy this to the ?Summary? sheet. Can this be automated using vba?
With regards to the ?Summmary? sheet, I have code that is easily adapted to break out data by Account Manager and be placed on individual sheets.
Your advice and help is always appreciated. Thank you. :)
Brian
I am hoping someone will share their expertise with filtering data by some criteria & then pasting the results to a separate sheet within the same workbook?
The attached file has 4 sheets: ?Customers?, ?Group-Codes?, ?SalesData?, ?Summary?.
?Customers? & ?Group-Codes? are provided solely to give some idea of the possible amount of data. The ?SalesData? sheet was limited to 3 Customers and 22 item Codes. Usually there would be 60 -100 Customers and 592 item Codes.
?SalesData? sheet provide sales figures for item Codes that belong to specific product Groups.
The ?Summary? sheet show total sales for the product Groups taken from the ?SalesData? sheet.
In the attached e the Customers were limited to 3 and item Codes to 22. More usually there would be 60 -100 Customers listed and 592 item Codes on the ?SalesData? sheet.
It takes an inordinate amount of time to copy each Cutomer name & Sales numbers from the ?SalesData? sheet then transpose this data onto a blank sheet? sum sales numbers? then copy this to the ?Summary? sheet. Can this be automated using vba?
With regards to the ?Summmary? sheet, I have code that is easily adapted to break out data by Account Manager and be placed on individual sheets.
Your advice and help is always appreciated. Thank you. :)
Brian