I'm pretty new to programming in Excel, particularly VBA. I have an Excel spreadsheet that I need to alphabetize. However, I need to alphabetize it by a group's heading, not just rows or columns. There's a bunch of buttons and text off to the right that make row operations impossible unless I copy/paste that section (shown in the attached picture) to the other sheet. But copy/pasting in a macro causes issues; like extra buttons.
C_HEADER
REV DATE ENG DFT REMARKS
0.0 01FEB2015 AA BB stuff
1.0 02FEB2015 AA BB stuff 59763
1.1 03FEB2015 AA BB stuff^2 sdf
2.0 04FEB2015 AA BB stuff #$%^&
A_HEADER
REV DATE ENG DFT REMARKS
0.0 01JAN2015 AA BB stuff
1.0 02JAN2015 AA BB stuff 59763
1.1 03JAN2015 AA BB stuff^2 sdf
2.0 04JAN2015 AA BB stuff #$%^&
B_HEADER
REV DATE ENG DFT REMARKS
0.0 01FEB2015 AA BB stuff
1.0 02FEB2015 AA BB stuff 59763
1.1 03FEB2015 AA BB stuff^2 sdf
2.0 04FEB2015 AA BB stuff #$%^&
How do I do this?
Some of the troubles I've been having is I'm trying to create a macro but extra buttons keep appearing when the macro executes.
I've attached a picture of part of the spreadsheet.
Bookmarks