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.