I'm not that familiar with the English Menu Items as I use a different MUI
language.
As far as I recall you can type the first 2-3 rows of the order-form and
declare them as a "LIST" (called: "Table" in "2007") Via DATA LIST.
Place the cursor at the last used row in that Table press Enter to open a
new row.
When all data ha been typed to that new row, all formulas, from previous row
should appear there automatically.
Micky


"Volntyr" wrote:

I am need of help on this as I have no idea if this is even possible in Excel
03.

I am currently designing a spreadhseet that will be used to order supplies
on a weekly basis. Sheet 1 is the order form while Sheet 2 has all the
product info. While Sheet 1 has no problem pulling the info from Sheet 2
(via VLOOKUP), the approval person is making this request

"Can you get it to automatically add another empty line at the bottom every
time a line has info entered on it? Will the new rows contain the formulas
from the previous rows?"

I know I can make a large sheet with as many rows as I want but he wants to
go ahead and have the exact number of rows needed each time so he can simply
press print instead of going thru the whole 'Selection' process on the Print
Menu.

Any help would be greatful