Update Version

[tigerdel]

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

 

[tigerdel]

Line 3 should have read:
If Coumn B is Approved then update number to next full number [i.e. 2.0]