Type auto serial number started

Hi,
I have a worksheet named Data and there my record will start from A2 and there i need a code of serial number started from 1001. If A2 is blank then the serial number will mention 1001 and if A2 have record then A3 will show 1002 like this. I have tried the below code but getting error. Request for help.

Please Login or Register  to view this content.

cysu11

Your macro does not continue down the column.
Try this :

Please Login or Register  to view this content.

Dear Mr. Logit and Mr. Cysu thank you both for revert with solution. But the code of Mr.Logit works for me. I don't know why the code of Mr. Cysu not works. Sorry.
Here i need this code to be worked in C column. Actually it's my mistake and had mentioned A column. In A column is my serial no. B is date and C is the Voucher no where i need this count started from 1001.
Secondly how to populate this code in userform textbox 2 with added next serial number. Hope i have explained clearly. Thanks

Hi,
Thank you all for your efforts..
I have tried both the code it is working where there is data already there. When there is no data it gave error. I need in C2 it will mention 1001 starting when there is no data and in Textbox10 starting show 1001 for the first data and then 1002,1003 etc. Attached file for your reference.
In addition I need the userform data will update in Data sheet as well as in Voucher sheet in the blank cells. Request you please look at this. I think i have explained well here.

Dear Bakerman Sir superb like every time. This is exactly fulfilled my work. Just little bit help to alignment the data.
In Receipt sheet all entries should be in left alignment. Here amount will show 1,00,000.00 for one lac and date when i will put 05-06-2025 it will update like 06-05-2025. Thats all. Thanks.

Thanks again and exactly the same result what i needed. I will apply to my original file and if any query will come will let you know. Will revert soon. Same result of Indian currency format you had provided.

Dear Sir,
In my userform i had done one small changes and added one combobox for payment mode and it will update the data but not work in refresh.
Secondly i want to upload userform3 data to userform2 and again it will create issues due to Combobox.
Request your help in this regard and attached file herewith.

Bakerman Sir the code have tried and works superb. Many many thanks for your support time to time.

Dear Sir,
I have added a macro to mention amount in words and in userform textbox 4 i need this code based of the userform3 amount changes. This i am trying and not getting to populate the textbox. This is my last query in this regard and request to help please.

Hi,
Please consider this attachment as in receipt sheet one code mentioned.

Bakerman Sir you are superb and help a lot. All the code is working fine and my issue here resolved. Thank you again.

Sir sorry to trouble you again. Now i am getting error at the time of Upload data of Userform3.

Please Login or Register  to view this content.

Here the cursor showing error and Userform2 not showing. In your form it is working . I have copied the same form and contains to my data but still get error.
Request you please explain what to do here.

Sorry it's my mistake and i have used other userform2 and i now just copied same your userform2 and works fine. Very sorry..