Hey guys,

Have put together a spreadsheet for backorders, and want to automate part of it to make it easier.

As its setup, i have a list of customers with various amounts of the same product, with an ETA for arrival down 1 column.

At the bottom of my sheet, i have purchase orders for various quantities, and ETA. This date can change on a weekly basis, and i want it to automatically update the ETA cells for the customers sales orders if i modify the purchase order date or quantities.

Here is a basic look of the layout :

2gserts.png

Thanks in advance.

Regards