I think I would arrange my data somewhat differently but you can do this
yourself by recording a macro while you hide/unhide the pertinent columns.

--
Don Guillett
SalesAid Software

"grin2000 " wrote in message
...
Attached is the sheet I'm working on. The 4 buttons above each of the 3
years and the sum need a specific macro that when you click on the
button, for example Yr1, it will take you to the other colums which
contain the more detailed 12 months of that year.
When it takes you to those 12 months the only thing thing I would like
to be seen is those 12 months (along with that year's summary which is
next to the last month of that year) on the screen. So that if someone
wants to print anything all they they would have printed is only what's
on the screen.
For the last button which is the 3yr Sum I just want it to show the
original yr1, yr2, yr3 and 3yr sum colums when clicked on.(again only
those 4 colums I would like to show in the screen for viewing and
printing purposes) Thanks, I appreciate it.

BTW....... all of the detailed months colums will be hidden the only
colums that will be unhidden are the 4 colums with the buttons above
them.

Attachment filename: buttons.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=571293
---
Message posted from http://www.ExcelForum.com/