Hello,
I am trying to obtain some assistance on a project I'm working on. I have a series of values in one worksheet across one row. The row contains "Yes" or "No" text and also some currency or other number values.
My spreadsheet looks like this (the blank shown is a cell that has no value or text):
Yes No Yes No (blank) Yes No $100 50% 5
What I'd like to do is to have a VBA code that assigns a value to each of these text and numerical values by the following criteria:
If Yes, Value = 0
If No, Value = 5
If "Blank", Value = 0
If $0 to $25, Value = 1
If $26 to $50, Value = 2
If $51 to $75, Value = 3
If $76 to $100, Value = 4
If 0% to 25%, Value = 1
If 26% to 50%, Value = 2
If 51% to 75%, Value = 3
If 76$ to 100%, Value = 4
If 1 to 5, Value = 1
If 6 to 10, Value = 2
If 11 to 15, Value = 3
If 16 to 20, Value = 4
Therefore, I want to have the outputs in another worksheet (sheet 2) and it should show the following numbers based on the criteria above:
0 5 0 5 0 0 5 4 2 1
Any help would be greatly appreciated.
Thank you!
Bookmarks