I need help with AutoFill VBA

[venkatpvc]

Hello Everybody,

Thank you all you support.

My Problem I have this below code. I need this below code to modify as everytime I enter text in
column B the marco automatically need to fill serial number in column A. I mean

A B
1 venkat
2 vani
3 raju
ramu
roudy

Please Login or Register  to view this content.

thank you for your help,
venkat

[venkatpvc]

Please Login or Register  to view this content.

I got It finally but I need help with it update everytime something added to column B

[FDibbins]

If you just want to have 1, 2, 3 4, etc in A based on if there is a value in B, you could do this with a very simple formulaA2, copied down...

=if(B2="","",A1+1)

[MickG]

Try:-

Please Login or Register  to view this content.

[venkatpvc]

If you just want to have 1, 2, 3 4, etc in A based on if there is a value in B, you could do this with a very simple formulaA2, copied down...

=if(B2="","",A1+1)

Thank you Sir,

Yes,

I dont want any formulas show on my sheet, so may be VBA can help me to do this. and I am learning VBA.

[FDibbins]

Thank you Sir,

Yes,

I dont want any formulas show on my sheet, so may be VBA can help me to do this. and I am learning VBA.

The formulas wont show, but Im sure some-one will give you tyhe code you want

[venkatpvc]

MickG,

That is Perfect, What I am looking for.

Thank you very much...........
venkat

[MickG]

You 're welcome
Regrds Mick

[JBeaucaire]

I've marked this thread as SOLVED for you.
Next time, select Thread Tools from the links above to mark a thread as SOLVED. Thanks.


Please start marking your threads as solved.