Create a New Sheet from Existing Sheet with Specific Columns

[malam]

I have a sheet with many columns (A, B, C, D, E, F etc.). I want to copy column B and E in to a new sheet. How do I do it in VBA?

[macropod]

Have you tried recording a macro? The macro recorder gives you the basic code you need, though it could do with come tweaking. Besides which, where do you want the copied columns to end up in the destination sheet?