Code Cleanup

[SmithStanley1212]

I recorded this macro to do what I need utilizing the macro recorder, it looks as if there is a bunch of un-needed garbage in the macro but I am not adapt enough to clean it up so that the garbage is removed. Can someone here assist me in cleaning up this code so that the garbage is removed from the syntax.

What I am wanting to accomplish with the syntax is:
'Delete Rows 1 and 2
'Copy columns B, E, R, N O, T, V to new worksheet
'Adding in the sort & sub-sort needed

Please Login or Register  to view this content.

[LeoTaxi]

best is excel file with before and after sheet

Cheers
Leo

[mehmetcik]

Please Login or Register  to view this content.