Macro for clearing contents and adding serial number after validating

[Mitiraj]

Hi all,

I am beginner and I need help in writing macros.

I have an excel with 4 columns(column A: DCODE(A1), column B: NAME(B1), column C: USERID(C1), column D : ROLE(D1)). I have values for all the cells in column A and some cells have values in column B.
I am trying to do the following.

1. Change the value of A1 from DCODE to SNO
2. Clear the values in column A (except the cell A1)
3. Check the value in column B and if it has a name then the serial number should be given in the column A. Serial number should be there only if a name is there in column B.


Please help.. thanks

[ikboy]

Try this:

[Mitiraj]

Thanks for supporting me.
After executing with the above code, noticed number generates from 1 to 4 in column A(for first 4 rows even though data is not there in column B).
From row5 number 2 is always displayed if it's null value in column B.

[ikboy]

Please upload a file and simulate an answer.

[Mitiraj]

Please find the attachment. It has the current output and the required output. thanks

[ikboy]

[Mitiraj]

First row (value of cell A2) is not changed. Remaining rows works correctly.

[sktneer]

Try it like this....

Please Login or Register  to view this content.

Or try this simple version

Please Login or Register  to view this content.

[Mitiraj]

Thanks a lot ikboy and sktneer. It works perfect now..
It solved my purpose. Thanks again

[sktneer]

You're welcome. Glad we could help.

If that takes care of your original question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

You may also say thanks to those who have put their time and efforts to help you in this forum by clicking the Add Reputation link under one of their posts, another way to say thanks.

[Mitiraj]

Sure will do it definitely.

One last thing whether is it possible to insert an empty row after each persons record. Thanks