I could use a little more help.... I want to have the output on a separate tab. I have the data on "MerchList" and I want the data on "Output". I tried adding two Sheets statements but it doesn't like the row after: Sheets("Output").Select
'Start Merch List...
I'm a novice VBA user. This seems like it would be easy but I can't figure out how to accomplish it. I'm trying to create a template that can be used to upload data into a system. I have half of it working. Now I need to take column of consecutive values and paste them next to another column...