Inserting rows

[Vicki]

Hi,

I am working on a spreadsheet for our sales staff and I need the spreadsheet
to automatically create new rows once they get to a certain point so that
they don't run out of rows to enter their data for the month. How do I do
this?

Thanks for your help--

 

[Vicki]

The spreadsheet is currently blank. I am trying to get it ready to go for 5
sales people. Does there have to be info in the cells? When I highlight to
a certain point on the spreadsheet and then click Ctrl L it beeps at me. I
don't want all of the sheet to add more rows, I want the rows added above the
total line and formulas for the commissions.

 

[Vicki]

up to row 49 is where they enter their data and on row 50 the formulas start
for totaling up the columns. I have the rows 50+ locked so they cannot
tamper with my formulas.

 

[Vicki]

I still can't get this to work. I have rows 50 + locked so that users cannot
change my formulas...could that be the issue?

 

[Vicki]

sounds perfect. However, when I do that and press ctrl-l, it just beeps at
me. any idea why?