Actually I figured it out. What I am stuck on is telling my VBA code to find the last value in a specific range. I know how to find the last used cell in a column, but I need to tell it to find last value in a specific range...then I can run a loop and do other stuff.

Any help would be greatly appreciated!

Ps. I will post the code later, I can not post it from my work computer. I am on a phone right now