so sorry for the late response work had sent me out of town and i have read all your responses but i havent made the macro yet but i can post pictures of the excel sheet if you guys want? and i am back in town will be answering faster very sorry for the late response