Insert Rows Automatically...

Hi all,

This may seem like a relatively easy question but I'm getting nowhere fast so thought I'd ask here.

I wish to have a new row automatically created when the last piece of data is entered into cell H11 for instance.
My row (H1:11) is made up of drop-down boxes and cells that refer to vlookups... and when a selection is made from the drop-down box in cell H11... I want a new row to be created underneath... This also needs to run on any consecutive rows that are created as a result of this... so... when the selection is made from H12, again, a new row is created and so on.

Hope you can help.

Gavin

Originally Posted by davegugg

Put this code in the code page for the worksheet that you want this to happen on:

Please Login or Register  to view this content.

Fantastic!! Thank you so much! Works a treat!
Is there any way I can make the highlighted cell become A12 rather than H12 once the new row has been inserted?

Originally Posted by davegugg

Just do Cells(12,"A").Activate

Thanks, that's great!! Although... I realised my mistake once I added the code...
I don't actually want A12 activated... I want the next cell in column A activated... So... When the last selection is made from column H... Say for instance H2, I'd like A3 to be selected and then when H3 has been changed... I'd like A4 to be activated and so on...

Hope that makes sense?

Brilliant! Thank you!

I have one more question... Sorry... I'm a complete newbie when it comes to VB and Excel.

I would like rows copied to seperate sheets within the same workbook... I have 25 sheets in total, each named with a room number... Ideally... I'd like a row which has information about the room G8 copied to the sheet G8 once the last selection has been made in column H. The same goes for any other rooms also. The idea is that each sheet will have a constantly growing list of entries for that particular room.

Thanks Dave!! Works perfectly!!

The cells on the master sheet are mainly drop-down boxes... Is there any way to copy these with just the values and not the list box arrow...

Thanks again for your help.

Gavin

Okay, no problem! Thanks!!

I have a vlookup in column B which works perfectly well on the master sheet but when the data is automatically copied over... The information in column B isn't written and I get a #REF!
in the cell...
When I click on the cell to see what's going on... This is what I see in the formula bar... =VLOOKUP(A2,DataSource!#REF!,2,FALSE)

I guess the vlookup formula isn't being copied over??

Also... When a new row is inserted automatically below on the master sheet, the vlook formula isn't being copied down either.

Any ideas?