merge columns into single report - macro needed

A

aquaflow

I need to build a macro to take COL 1 COL 2 etc and created new
worksheet with these columns using a macro. please help
 
B

Bob Phillips

Public Sub Test()
Columns("A:B").Copy
Worksheets.Add
ActiveSheet.Paste
End Sub


--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
A

aquaflow

Public Sub Test()
Columns("A:B").Copy
Worksheets.Add
ActiveSheet.Paste
End Sub
Click to expand...

Bob,

how do i change if the columns are different like COL2 COL5 COL7 COL9
COL12. and rename the sheet to a new name once i do this.

Thanks
 
Top