Trying to make a duplicate roster with a button.

  • Thread starter Thread starter virtex
  • Start date Start date
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
+-------------------------------------------------------------------
 
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
********************************
 
Back
Top