VB sort and filter - see attached

kevin gave me a sort and filter example worksheet, in response to my last question, that uses VB.  i'm not good at all with code and don't understnad how to apply it.  attached is that workbook and also the one that i want to put it into.
Sort-and-Filter-Example-1-.xls
SotW-r2009.xls
douglascarleydotcomAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

zorvek (Kevin Jones)ConsultantCommented:
This is your lucky day :-)

See attached.
SotW-r2009.xls

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
douglascarleydotcomAuthor Commented:
you are awesome.  i'm going to get "kevin is the greatest!" tatooed around my left nipple.  it'll be in skin tone ink, but we'll both know it's there.

i'm in awe.  thank you.
douglascarleydotcomAuthor Commented:
if i copy the sheet, will the code adjust or do will i need to fix anything?
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

zorvek (Kevin Jones)ConsultantCommented:
Copying the sheet should work but I have not tested it.

Would mind posting your grading comment in a regular post? I want to add it to my list of accolades: http://www.experts-exchange.com/M_1677072.html

Kevin
douglascarleydotcomAuthor Commented:
you are awesome. i'm going to get "kevin is the greatest!" tatooed around my left nipple. it'll be in skin tone ink, but we'll both know it's there.

i'm in awe. thank you.
zorvek (Kevin Jones)ConsultantCommented:
:-)
douglascarleydotcomAuthor Commented:
kevin,
i tried copying the sheet.  the filter works but the sort doesn't.  i update and change this workbook on a weekly basis.  what will i need to change in the code when adding a new sheet?
douglascarleydotcomAuthor Commented:
i figured it out.  the shape you have placed are assigned to the macro from the first sheet (a guess).  i right clicked and assigned the sortheaderclick macro to them.
zorvek (Kevin Jones)ConsultantCommented:
You can also delete all the shapes and recreate them by selecting the cells over which you want the shape and running the macro "Sort_CreateHeaderHotArea".

Your method is a lot faster though if you select all the shapes and assign the macro in one step.

Kevin
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.