I've put together a gas mileage spreadsheet. It's real simple. I enter a
row and it calculates the mileage. The thing is, it gets it's beginning
odometer reading from the ending odometer reading of the previous entry. And
rather than start at the top of the spreadsheet and add new entries at the
bottom, what I'd like to do is add entries at the top.
How do I do this, and have my formulas in the new row?

1/3/2006 2.079 41.503077 19.963 168139 168589 450 22.54170215
168139

These are rows 2 and 3. I have a header row (1).

How do I insert a new row at 2, that will have the formulas and push these
two rows down, making them 3 and 4?

I would record a macro, see here for instructions:
http://www.helpwithpcs.com/tipsandtr...o-tutorial.htm
Or, search Google for "Recording a macro excel" for further info..


--
cycling-rod
------------------------------------------------------------------------
cycling-rod's Profile: http://www.excelforum.com/member.php...o&userid=13520
View this thread: http://www.excelforum.com/showthread...hreadid=505612