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