Automatically adding additional rows

[Volntyr]

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

 

[Sheeloo]

Yes, it can be done but using macros written using VBA (Visual Basic for
Applications)...
You can provide a button, which when clicked can add one blank line at the
end...

The code needs to identify the last filled line to do this... also you need
to take care that any formula on the last line is not impacted...

I can do this for you if you can upload your file on wikisend.com and paste
a link here.

I can provide a sample code if you have done some macros in Excel.

 

[מיכ×ל (מיקי) ×בידן]

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]

orderver3.xls