Output date from changing cell range

**kolonel** · 07-27-2012, 01:37 AM

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

**ratcat** · 07-27-2012, 09:29 AM

G'day and welcome to the forums,

I think if you like more help on your excel challenge, it might be best for you to help us first in supplying a dummy spreadsheet of a before and after scenarios.

Cheers

**kolonel** · 07-28-2012, 02:45 AM

Thanks for the heads up !

**kolonel** · 08-02-2012, 01:51 AM

Originally Posted by ratcat

G'day and welcome to the forums,

I think if you like more help on your excel challenge, it might be best for you to help us first in supplying a dummy spreadsheet of a before and after scenarios.

Cheers

Thanks for the tip.

Is there another way i can show the sheet, or is attachment the best option.

Thanks again.

**ratcat** · 08-03-2012, 08:19 AM

G'day

See attachment. As you can see you must have in column C matching PO# or SO# to make it work.

**kolonel** · 08-03-2012, 08:58 AM

Thanks for looking into this mate, it is much appreciated.

I have attached the sheet again, with some comments which i hope make sense.

Thanks again.

Kolonel-sample.xls

**kolonel** · 08-08-2012, 11:43 PM

sample.xls

Have modified the sheet to reflect the results based on numbers given.

What the ultimate goal for this sheet is to be able to put the dates from the next available purchase orders to fill stock levels. The values that can change are the following :

Date the purchase order is due (A11-A15)
The amount that is coming in on that purchase order (E11-E15)

I was hoping to fill the dates (J3-J6) based on the numbers in the H column, and once the number was greater than the sales order, would use the corresponding purchase order date.

Will be most appreciated to have this solved.