Hi everyone,

I have a worksheet with lots of random rows and columns. I would like to use VBA to find 3 specific columns, copy those columns and paste them into a new sheet. What would the code look like?

Ctrl+f doesn't seem to work very well because after highlighting my first column, i want to search for my next column but excel will run the search in the highlighted column.

I tried using relative references, but again that wouldn't work because the second column I need might be 6 cells to the left on the first worksheet, but 2 cells to the right on the second worksheet. Any thoughts? Thanks in advance!