G
grin2000
I have 4 colums named Yr1 Yr2 Yr3 and 3yr Summary all from A to D. Nex
to those colums starting from E are hidden colums all having mor
datailed info from each of the 12 months of that certain year.
What I don't know how to do is to assign the correct macro that when
click on one of those buttons (for example Yr1) I want it to g
straight to those 12 colums with each of the months but I want it t
show the "view" of all 12 months on 1 page so that when someone print
it out just those 12 months will be printed out.
I also want all those 4 buttons to stay in place and not go away once
click on them. So if someone can help me with the code for the macr
that can send me straight to the detailed 12 months "view" once I clic
on the button I appreciate it.
I would like to know how to set up a "view" for a certain range o
cells that when I click a button which sends me to that certain vie
that that will be the only thing seen on the screen and when I print i
out, nothing else. Some of the views aren't as big as others and
wanted to know how to format the view to have it fit nicely on one pag
even if one's larger than the other. I really appreciate the help
to those colums starting from E are hidden colums all having mor
datailed info from each of the 12 months of that certain year.
What I don't know how to do is to assign the correct macro that when
click on one of those buttons (for example Yr1) I want it to g
straight to those 12 colums with each of the months but I want it t
show the "view" of all 12 months on 1 page so that when someone print
it out just those 12 months will be printed out.
I also want all those 4 buttons to stay in place and not go away once
click on them. So if someone can help me with the code for the macr
that can send me straight to the detailed 12 months "view" once I clic
on the button I appreciate it.
I would like to know how to set up a "view" for a certain range o
cells that when I click a button which sends me to that certain vie
that that will be the only thing seen on the screen and when I print i
out, nothing else. Some of the views aren't as big as others and
wanted to know how to format the view to have it fit nicely on one pag
even if one's larger than the other. I really appreciate the help