Ok wondering If there is a faster way of doing this.
I have a list of suppliers with their products and sales information
to work out the days cover I add the total of product on had and divide it by the total of the average weekly sales.
To get this though I have to subtotal all the data then put in the formulas on each line is the suppliername alongside the product description and sales information.
I need to be able to access this information quickly so the current method is a bit slow, and changes the data around.
Any Ideas Vba or Formula orientated?
Brett
Example
This message was edited by brettvba on 2002-09-09 20:15
I have a list of suppliers with their products and sales information
to work out the days cover I add the total of product on had and divide it by the total of the average weekly sales.
To get this though I have to subtotal all the data then put in the formulas on each line is the suppliername alongside the product description and sales information.
I need to be able to access this information quickly so the current method is a bit slow, and changes the data around.
Any Ideas Vba or Formula orientated?
Brett
Example
Book1 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
2 | Supplier | Product | TotalInStock | AverageSale/Week | ||
3 | Supplier | Product | TotalInStock | AverageSale/Week | ||
4 | Supplier | Product | TotalInStock | AverageSale/Week | ||
5 | Supplier1 | Product | TotalInStock | AverageSale/Week | ||
6 | Supplier1 | Product | TotalInStock | AverageSale/Week | ||
7 | Supplier2 | Product | TotalInStock | AverageSale/Week | ||
8 | Supplier2 | Product | TotalInStock | AverageSale/Week | ||
Sheet1 |
This message was edited by brettvba on 2002-09-09 20:15