I guess what I don't know how to do is get the rest of the addresses from sheet 3 onto sheet 1 in the format that they are on sheet 1. For what I attached I copied and pasted each cell over. I had hoped I could highlight what I did and then drag it down to have it keep copying the data, but it doesn't copy the correct cells. I just don't want to have to copy and paste each thing for the next 100 entries. And the list I have on there isn't complete yet, though when finished it will follow the same pattern.