VBA codes auto numbering in clolumn A when the user enters information in an adjacent cell

[wowow]

Hi Everyone,

Could you please help send me VBA Codes to enable VBA codes auto numbering (1, 2, 3, ....) in clolumn A (A2, A3, A4, ...) when the user enters information in an adjacent cell let's say B2, B3, B4, ....?

Thanks and Kind Regards,

[jewelsharma]

try this

Please Login or Register  to view this content.

[wowow]

Thank so much jewelsharma,

Could you please provide me with the sufficient codes that enable deleting the numbers already fill in cells in column A when the corresponding values in cells in column B are deleted?

Best Regards,

[jewelsharma]

is the above code not doing so already? it is supposed to.

[wowow]

Hi jewelsharma,

The codes only generate numbers, not delete the generated numbers relevant to the deleted values in column B.

Could you please help me?

Thanks

[jewelsharma]

see attached.

[wowow]

Hi jewelsharma,

Thank for your file, but I still see the numbers existing in column A after I delete some values in column B. I don't know how to do.

Could you please help me?

Thanks

[jewelsharma]

That's surprising! (I take it that you have enabled the macros).

Are other forum members able to help us verify that the code is working as expected. i.e. Starting from cell B2:

1. Provide a serial number in column A when anything is entered in the corresponding cell in column B.
2. Delete the serial number in column A, if the corresponding cell in column B is deleted; and renumber the cells accordingly.

Experts, here's the code for your quick review:

Please Login or Register  to view this content.

I have the same Excel version as OP and it's working as expected for me, but the OP reports issue with deletion of the serial number. Am I missing something?

[jindon]

Try

Please Login or Register  to view this content.

[wowow]

Thanks jindon

It seems there are still something that need be refining to ensure your codes run well.

Could you please check and help me?

Thanks

[jindon]

Thanks jindon

It seems there are still something that need be refining to ensure your codes run well.

Could you please check and help me?

Thanks

How is it not working?

[wowow]

Actually, when I put the value in column B but not in the continuous row the continuos numbers is appear in the blank row. Furthermore, the numbers are still shown when I delete the value in the column B.

[jindon]

Upload a workbook with your desired reult.

Your explanation is confusing us.

[wowow]

Hi Jindon,

Please help me with the attached file where there is some details of requirements.

Thanks

[jindon]

If an Invoice ref no. cell is filled, the corressponding and continuos item number is automatically filled. When any Invoice ref no. is deleted, the corresponding number is automatically deleted too and re-numbering the remaining numbers

What do you mean by "corressponding and continuos item number is automatically filled"?

[wowow]

Hi jindon, "corresponding and continuous item number is automatically filled" mean that the continuous and integral numbers only and these numbers are automatically generated by Excel itself. Thanks

[jindon]

Do you just want to number in col.A only the cell(s) col.B has value?
Is that what you mean?

[wowow]

I just want to number in cell(s) of col A in case the corresponding cell(s) of col B has/have value(s).

When the value(s) in cell(s) of col B is/are deleted, the corresponding number in cell(s) of col A is/are automatically removed.

[jindon]

Please Login or Register  to view this content.

[wowow]

It works! Thanks jindon. Good day.

[jindon]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.