My spreadsheet in some cases automatically adds a row below how?

[dister]

I have a spreadsheet that tracks certain data. The tracking is broken down
into 4 sections each section having 10 rows. For the first section if i go to
the end of the row there are two blank rows as soon as i add any data to one
of the blank rows, excel automatically adds a row below that section. How
does it do that? I would like to do the same to the rest of the sections.

 

[Gord Dibben]

If Excel 2007 sounds like you have "Tables" from Insert>Table

If Excel 2003 it would be "Lists" from Data>List>Create List


Gord Dibben MS Excel MVP

 

[dister]

thats what i thought but three is no code?
D

Probably with a worksheet_change event macro. Right click the sheet tab>view
code>look

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)

 

[dister]

I did have a list so that i can drop down the different issues, but it
appears to be a partial list.

 

[Gord Dibben]

Which version of Excel?

Are your sections outlined with a blue border?

If you go to Data>List what is available for selection?


Gord

 

[dister]

I am using 2007 with the Tables feature. The original spreadsheet was
created in 2003. I am currently trying to figure out how a cell can
automatically be added using 2007. I have created a new table but am still
struggling to have excel automatically add an additional row as i add data.
D