Trying to make a duplicate roster with a button.

V

virtex

Hi everyone, I'm new to this forum and have used excel for basi
spreadsheets for awhile now, but I want to start some more advance
stuff.

Here is what I'm looking to do I have a 4 sheet book with A-H Col bein
used and 100 or so rows. I would like to make a Cover sheet that relate
to the rest so I can hide the sheets, but use the buttons on the fron
page to navigate. Also I would like to make a button that creates a ne
page with all duplicats from each sheet on one sheet seperated by page.

If you don't quite understand I'll try to explain a little better, bu
need as much help here as I can get. Its Due by COB today.

Can you also tell me if this is not possible, or at least say somethin
so that I don't feel like a complete retard :)

Thanks for the help guys.

Here is a sample

+-------------------------------------------------------------------
|Filename: sample.zip
|Download: http://www.excelforum.com/attachment.php?postid=2681
+-------------------------------------------------------------------
 
A

Anne Troy

Ok, retard. LOL!! Don't belittle yourself! Most people don't ask, they just
plow through. My first thought is...why not have all your data on one sheet
to begin with? Then use Data-Autofilter and Data-Subtotals to get individual
groups of data.

You can record macros that filter and sort and subtotal and clear those (for
the most part). Then make textboxes (drawing toolbar), right-click and
assign the macros to them.
**** Hope it helps! ****

~Dreamboat
Excel VBA Certification Coming Soon!
www.VBAExpress.com/training/
www.Brainbench.com Word Test Developer 2000,2002,2003
********************************
 
Top