Automatically add multiple new rows when data is entered into the sheet.

Hi Guys,

The thing I am wanting to do is much easier to explain with an example, please download the attachment and have a look.

I want there to ALWAYS be 5 FREE/EMPTY rows to be able to enter data into them
I also want the black area around the outside to ALWAYS be a further 15 rows in height below that.

Sheet 1 = Simple Example
Sheet 2 = A much larger example
Sheet 3 = Erroneously added data should still extend the sheet by 5 rows each time.

Thanks in advance
- Ryan

Put into sheet1 code:

Please Login or Register  to view this content.

Assuming you maintain your formula in column N & O of the first black row

Please Login or Register  to view this content.

Hi stnkynts,

Running that code is hitting the same problem that I was hitting when I first modified your code, if you click in A15 and put a random character, N15:O16 aren't given the right formula. See http://i.imgur.com/7scLVrX.png

I fixed the majority of it in the following code, the best way I've found but someone else might be able to still improve this...

Please Login or Register  to view this content.