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

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.

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

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.

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

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.

My spreadsheet in some cases automatically adds a row below ho
 

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.

My spreadsheet in some cases automatically adds a row below ho
 

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.

My spreadsheet in some cases automatically adds a row below ho
 

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.

My spreadsheet in some cases automatically adds a row below ho
 

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.