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