So I'm trying to make a macro to basically copy and paste imported information and make it look pretty in the excel sheet. The imported data can change all the time, so I'm using a lot of if thens. Heres an example of my imported data:
A B C D E F
Chicago...