Advanced Filter + Several Macros

hey Ryan?

Think positive & give it a go, teachers aren't there to give you all the answers & neither are individual textbooks - join the rest of us on our journey of guided/self directed discovery!

You can't go wrong recording a macro - something will record & either it will be functional or it will need some/a lot of tweaking & that's where first the [F1] key & second the Forums can come in...

Most of the people floating around on this Forum are very helpful & know their stuff, but I don't know of anyone who wants to complete someone else's assignment from (what appears to be scratch, even if it is only part of a bigger assignment).

We are usually willing to help with specific challenges that you have, if give some examples of what you have tried but I can see nothing in the VBE for the file you have attached - although there are references in the macro buttons to macros in another file eg "\sem2-07\LanguagePlus0702RR.xls'!showall" (it may help if you attach this/these other files).

Give it a go...
Try recording each part of the process as individual macros & then reviewing the code by stepping through it in the VB Editor using [F5] to go line by line. Once checked, multiple macros can be run one after the other in a "master macro" by putting the name of each macro on a new line down the page or merging each code snippet into the master macro.

If you have any problems check out the appropriate links on the below link from OldChippy's signature:
http://www.excelforum.com/showthread.php?t=584092
or any of the MVP's in the below list may have usuable examples on their websites:
http://www.mvps.org/links.html#Excel
and then try asking a specific question...



Good luck!

Rob