I have a repetitive task daily that could go away with the help of VBA. I have a sheet that lists a large group of retail stores. In column "U" of the sheet "Future_Launch_Locations" it has the state that the store is in. In column "N" I need to fill out an HVAC Provider. A second sheet "HVAC Provider" has in column "A" all states and in column "B" the associated provider for that state. I would like to run a macro that quickly does the vlookup or equivalent VBA action, and paste the associated provider into column "N" of the "Future_Launch_Locations" worksheet for me.