I have a large data table that contains a column indicating a persons age banding, the bandings are displayed as:
1, 2, 3, 4, and 5.
I want to write a sub to select column D (the age banding column) then to check the value in cell D2 and if value = 1 then replace value with text "Under 18"
if value = 2 then replace with 18-64, if value = 3 then replace with 65-74, if value = 4 then replace with 75+, and if value = 5 then replace with age unknown.
Once the sub has checked replaced cell D2 i want it to do the same for cell D3 and D4 etc until the end of the database (row 1600)
I know this shouldnt be too dificult to do but im new to VBA and need some help, so far my (incorrectly syntaxed) sub looks like this: