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.

Probably with a worksheet_change event macro. Right click the sheet tabview
codelook

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dister" wrote in message
...
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.

thats what i thought but three is no code?
D

"Don Guillett" wrote:

Probably with a worksheet_change event macro. Right click the sheet tabview
codelook

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"dister" wrote in message
...
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.

If Excel 2007 sounds like you have "Tables" from InsertTable

If Excel 2003 it would be "Lists" from DataListCreate List


Gord Dibben MS Excel MVP

On Tue, 7 Jul 2009 10:36:01 -0700, dister
wrote:

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.

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

If Excel 2007 sounds like you have "Tables" from InsertTable

If Excel 2003 it would be "Lists" from DataListCreate List


Gord Dibben MS Excel MVP

On Tue, 7 Jul 2009 10:36:01 -0700, dister
wrote:

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.

Which version of Excel?

Are your sections outlined with a blue border?

If you go to DataList what is available for selection?


Gord

On Tue, 7 Jul 2009 11:04:03 -0700, dister
wrote:


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

If Excel 2007 sounds like you have "Tables" from InsertTable

If Excel 2003 it would be "Lists" from DataListCreate List


Gord Dibben MS Excel MVP

On Tue, 7 Jul 2009 10:36:01 -0700, dister
wrote:

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.

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
"Gord Dibben" wrote:

Which version of Excel?

Are your sections outlined with a blue border?

If you go to DataList what is available for selection?


Gord

On Tue, 7 Jul 2009 11:04:03 -0700, dister
wrote:


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

If Excel 2007 sounds like you have "Tables" from InsertTable

If Excel 2003 it would be "Lists" from DataListCreate List


Gord Dibben MS Excel MVP

On Tue, 7 Jul 2009 10:36:01 -0700, dister
wrote:

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.