I am looking for VBA code to evaluate the contents of every cell in Column B (if it has any cell contents - there will be something there, I just dont know how many rows there will be so I dont know where to stop evaluating).
Basically I want code to be:
If B2 = "PRE-FUNCTIONAL", then C2 = "Pre-Functional Commissioning" OR If B2 = "FUNCTIONAL", then C2 = "Functional Commissioning"
If B3 = "PRE-FUNCTIONAL", then C3 = "Pre-Functional Commissioning" OR If B3 = "FUNCTIONAL", then C3 = "Functional Commissioning"
If B4 = "PRE-FUNCTIONAL", then C4 = "Pre-Functional Commissioning" OR If B4 = "FUNCTIONAL", then C4 = "Functional Commissioning"
And so on and so on for as many rows there are data in column B.
I know this request is easily done with a simple =IF() within the C1 then copied down - but I dont want formulas with the cell - I want the actual words (so I know I can copy and paste as values, but thats all manually done - so thats why I want VBA).
Bookmarks