THANKS!! this is very close to what i need, instead of just naming the cells in column D i need it to also capture all cells to the left and right.

so for example in the file that i uploaded "newnt" would be from A10 O15