OK ... what I have is

A B C D
A unit # B miles C revenue D rpm
1013 2,585 $3,415 1.32
1077 2,004 $3,408 1.70
1099 3,187 $5,126 1.61
1103 3,256 $4,382 1.35
1177 2,794 $4,516 1.62
1182 3,946 $5,450 1.38

BC and D are all derived from formulas based on A (a VLOOKUP array from
another sheet). I have rows underneath (1182) that appear blank but are
loaded with the same formulas so that if you type (1111) below (1182)
then BC and D all fill in accordingly. What I want is a way that when I
insert (1111) and hit enter, it automatically sorts within this group of
numbers in A. So inotherwords it will read 1103, 1111, 1177 and then
1182. What do ya think? Is it possible?


--
goodpasture
------------------------------------------------------------------------
goodpasture's Profile: http://www.excelforum.com/member.php...o&userid=23898
View this thread: http://www.excelforum.com/showthread...hreadid=375314