Automatic numbering based on last number

Hi @ll,

Maybe someone will help me with below.

I have got 2 sheets:
- list (list of transactions)
- accepted (accepted transactions).

I want to make macro, which will:
1. select max value from sheet.accepted "B:B"
2. enter max value +1 in sheet.list "B8"
3. automatic fill down from B9 to the end of list with number increasing by 1 (in B9=B8+1, in B10=B9+1 etc.)

I tried with this:

Please Login or Register  to view this content.

but of course it's not working (lack of Excel skills).

Any help would be much appreciated.

Best,
Makafi

Maybe something like this:

Please Login or Register  to view this content.

It would really help to be able to see what's going on in the "list" sheet. Selecting the range from B8 to ??? is critical and it would help to see what's actually there to start with versus what you want when the macro is done.

Perhas you could just use:

Please Login or Register  to view this content.

Though I'm not sure why you need to constantly reset these... couldn't you just leave them in place all the time ? ie set B8 to =MAX(Accepted!B:B) and the others to be +1 of the prior cell or null if A <> "" ?

See, this is why it pays to SEE the data. There's nothing there to replace, so we need to "lastrow" Column A instead. Simple enough.

Please Login or Register  to view this content.