Hi,

Need some urgent help. Here is what I'm trying to do:

I have a number of machines at different locations. There is a list o
dates which specify the end of life for a machine. When that life end
we need to replace the machine or buy a new machine. We can replace i
by another machine from our fleet if there is a machine whose revenu
is less than 30.

So we go through the date list one by one (in the sorted order so tha
we attend to the machine which has the earliest end date), find
replacement for it (which has revenue less than 30- if it doesnot hav
any replacement we say buy a new one). And we can display it any forma
on a new sheet.

In my excel workbook I have 2 worksheets. In the DATE worksheet I hav
2 columns, one with machine locations and one with end of life dates
They are sorted in ascending order of end of life. In REVENU
worksheet, I have information about revenue earned by each location fo
every year for a period of 15 years.

I've been trying to do this for long and need to get it done asap
Please help. I can even send you the workbook if you email me a


I really appreciate the time you have taken to read this post :) Thank
a lot

Ker

--
Message posted from http://www.ExcelForum.com