Hi,
I am new to the forum! my friends talk a lot about this and glad to be in the forum using Office 2007.

My question---
I work in a manufacturing company which makes different sizes of Nuts on many machines. One machine can do only one size of Nuts for a particular period and can be molded for another variant.I manage an excel sheet defining the date ranges of the machine utility for a particular Nut, this allows us to mark our next point for another size.

The problem is.. after fixing dates for a process on a machine, I many time loose track of the previous marked dates and issue new dates for the same machine that is usually overlapping and lately found out.

Please help me with a solution ~~~ which does not allow overlapping of dates on a particular machine unless the previous dates alloted be changed.

Machines Start date End date
Machine 1 1/25/2011 2/7/2011
Machine 2 1/2/2011 1/25/2011
Machine 3 1/2/2011 1/25/2011
Machine 1 2/19/2011 3/22/2011
Machine 1 1/27/2011 2/11/2011

I use the Table feature of Excel 2007 for this data