Luis Diaz
asked on
VBA Excel : Update values based on a numerical sequences
Hello experts,
I am looking for a VBA to update the various values if values of next column are not empty ex:
The macro should be automatically enter all the numeric sequences as of A2 : 1st Comparison, 2nd Comparison... if data reported in Column B is not empty.
If ordinal number are complicated to report It will be acceptable to report like this :
1 Comparison, 2 Comparison etc...
Thank y ou very much for your help.
I am looking for a VBA to update the various values if values of next column are not empty ex:
The macro should be automatically enter all the numeric sequences as of A2 : 1st Comparison, 2nd Comparison... if data reported in Column B is not empty.
If ordinal number are complicated to report It will be acceptable to report like this :
1 Comparison, 2 Comparison etc...
Thank y ou very much for your help.
ASKER
Working perfectly.
I forgot to specify the following requirement: bold all the values reported in column A. Is there a way to integrate this in your previous code?
I forgot to specify the following requirement: bold all the values reported in column A. Is there a way to integrate this in your previous code?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Tested and it works!
Glad to know that. :)
I think you forgot to mark your question Solved by selecting the accepted solution. Please find some time to do that. :)
I think you forgot to mark your question Solved by selecting the accepted solution. Please find some time to do that. :)
ASKER
You are right. Sorry for that.
Never mind. :)
Open in new window