Copying multiple columns into a new sheet

[shivanikharbanda]

Hey,

I am new here and I've been browsing to find a solution but I may be missing it.

I have information on Sheet1 and I want to copy everything in Column E, Y, and AH. I want to copy and then paste this information into Sheet2.

Let me know if anyone can help. Thank you!

 

[Joe4]

Welcome to the Board!

What columns will you be pasting this information to on Sheet2?
The same columns, or something else (like A, B, and C)?

 

[shivanikharbanda]

It would be something else, A, B, and C

 

[Joe4]

If you turn on the Macro Recorder, and record yourself performing these steps manually once, it will give you VBA code that will do this.
(It will have a lot of Select statements that can be cleaned up a bit if you like, but will still work nevertheless).

 

[shivanikharbanda]

Thanks! It worked.

 

[Joe4]

Your welcome.
Yep, that Macro Recorder is a handy little tool. Even us programmers who have been using VBA for years use it to get tidbits of code!