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?