Macro for defining a range

[studentUH]

Hello this is my first post and i am in need of help. I need to have a macro that will automaticaly create ranges. (define a range) .

I would like a macro that would look in column D and look for the section that has "2" and name that section "oldt", if "7" name new "newnt", if "8" name "newt". The last column will always be "O"

I have attached what the file i am working looks like.

Please help if you can.

Thanks