Ok figured out how and where to enter the "code" in excel using the developer tab and running it... I got an error 9... Subscript out of range.....not sure what to do about that??
Please help in getting rid of the error, thanks rcm for your help!!