Inserting rows

  • Thread starter Thread starter Vicki
  • Start date Start date
V

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--
 
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.
 
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.
 
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?
 
sounds perfect. However, when I do that and press ctrl-l, it just beeps at
me. any idea why?
 
Back
Top