Hi All
I have a Userform that passes its values to the next empty row and now I need to update the version number column.
If cell in column B is Draft then find last draft version and add 0.1 to the value in column A unless if last draft version is less than last Approved version then in that case add 0.1 to the last approved version number, and;
If cell in colmn B is Approved then find last approved number and add add 1
I am hoping someone will look at this and say "any idiot can do that" and just send the code or formula because I simply can't work it out
Thanks for your help guys
I have a Userform that passes its values to the next empty row and now I need to update the version number column.
If cell in column B is Draft then find last draft version and add 0.1 to the value in column A unless if last draft version is less than last Approved version then in that case add 0.1 to the last approved version number, and;
If cell in colmn B is Approved then find last approved number and add add 1
I am hoping someone will look at this and say "any idiot can do that" and just send the code or formula because I simply can't work it out
Thanks for your help guys