Using: Excel 2010
I have a large worksheet (see attached excerpt) with strings in one column which look like:
Let's assume these strings define whether some modification needs to be applied to a particular building number like B0, B1, through B8.
I'm needing to apply a 'Y' (for 'Yes') into a corresponding column (there is a column for B0 through B8) which will make it easier to subsequently to sorts on those columns by building number.
I'm not familiar enough with VBA yet to write this code quickly and could use some help.
A look at the attached spreadsheet sample should make the above goal/need clear.