Well, I am trying to copy column A, C, and E using CTRL+click. I went to another workbook to paste it by right clicking and use "Paste Special" but for some reason it show another window first where you need to choose either "Paste" or "Paste Link". Under Paste Link there are a lot of things to choose from the list. I chose one and when I clicked OK, it copied Coulmn A, B, C, D, and E. Why it's like that? I only choose column A, C, and E and not all of the columns?

Please help!