Would it be more practical to have the automated feed go to anothe
cell?

Example:

B4: (automated feed)

A3: 100,000
A4: =MIN(MAX(A5,B4),A3)
A5: 50,000

Something you can work with??

Regards,
Ro

--
Ron Coderr
-----------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...fo&userid=2141
View this thread: http://www.excelforum.com/showthread.php?threadid=39529