Autofill next column row in a table

Hi,

I have a table with the first column heading named "Quote Nr".

Please Login or Register  to view this content.

I want to run this code to add a new row to the bottom of the table and update that row with textbox values on a userform.

My only problem is the first column of that new row needs to be the next number in the column of that table.

Column numbers are as follows

JN-01
JN-02
JN-03
JN-04

So the next number when I add a new row would need to be JN-05

anyone any ideas of how this could be done?

Thanks

Always easier to help on this sort of thing with a sample workbook, but as we do not have one of those I'm guessing here....

Please Login or Register  to view this content.

BSB

Thanks very much for your help. I tried this and it worked perfectly!

Sorry I shouldve explained better. This is picking up the row number which wont necessarily be correct. It needs to be "JN-19" then add 1 from the previous row

eg row 1 could be JN-1937 so the number to the new row will be JN-1937 +1 to get JN-1938

Would this be simple enough to do?

Thanks for your help

Originally Posted by colin7

Sorry I shouldve explained better. This is picking up the row number which wont necessarily be correct.

And this is why we ask for a sample workbook.

Post one of those and we can help further.

BSB

I have done a quick example

Thanks

Does this work?

Please Login or Register  to view this content.

BSB

BadlySpelledBuoy, This now works perfectly. Thanks for taking the time to help me with this, it's much appreciated!