I asked this before and perhaps there was not enough information, so I will
try again.

We are a wholesale distributor with 8 branches across Canada. We also have
a large quantity of product sitting in the wrong locations. I need to know
how to take that product and distribute to locations that are selling the
product.

The example that I gave is as follows, if more information is required, or
further explanation is needed I would like to know. This situation is
critical, and I would like as much input as I can get. So anyone out there
that can assist me would be wonderful. Thank you.

Example:

Whse 1 Product: XYZ 30 each This is all in overstock for this
warehouse.

Whse 2 Same Product has 10 each in inventory and Usage is 5 over the
past 3 months.

Whse 5 Same Product has 2 each in inventory and usage is 10 over the past
3 months.

I would like to move the 30 from warehouse 1 to warehouse 2 and 5 with the
appropriate quantities according to their on hand and usage.

I also have on the same spreadsheet:

Whse 1 Product ABC, with 200 in overstock.

Whse 3 Same Product has 300 in stock and usage of 100 over the past 3
months.

Whse 6 Same Product has 100 in stock and usage of 100 over the past 3
months.

and so on.

I need help on creating a formula that would do the bulk of the distribution
for me, taking into account the usage over the past few months, and the
quantity already on hand.

I am working with Excel 2003, and if anyone has any tips I would appreciate
it.

Thank you again.