Self Updating Copy of a Sheet

[StompS]

I have a lot of columns and need different views at a glance. I am thinking
of creating copies of the worksheet and hiding columns that aren't needed
for certain views. How can I have multiple copies of the sheet so, as the
master is changed, it updats the copies? Thanks!

 

[broro183]

Hi,
Try creating custom views by setting up the page with certain columns
hidden & then creating the view [alt+v+v] "add".
This approach prevents the need of creating copies of a master sheet &
therefore decreases likelihood of inaccurate data caused by "two
versions of the truth".

Once all your views are created you can quickly flick from one to
another using [alt+v+v] again. If you want to take this one step
further & link views to a dropdown box, Ed Ferrero provides a "view
selector" example, http://www.edferrero.com/Content/ViewSelector.zip
from http://www.edferrero.com/VBA.aspx, which will give you a starting
point.

Hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

 

[StompS]

Thanks for the help....will I be able to print the particular views without
cicking on a view, printing, then clicking on another vire, printing, etc?
Thanks!

 

[broro183]

Hi
Yes, you should be able to - after each view is checked for layout etc
Are you familar with macros?
If so, try adapting the code below, if not, let us know.

Note, it will currently show the printpreview for each page on th
activesheet. I would work through these first to make sure that th
sheets will print as expected & then comment th
"activesheet.printpreview" line & remove the " ' " from th
"activesheet.print" line.

Sub PrintCustomViews()
'modified from Excel help file search = "customview"
Dim CstmVw As CustomView
For Each CstmVw In ActiveSheet.CustomViews
CstmVw.Show
ActiveSheet.PrintPreview
'* ActiveSheet.Print
Next
End Sub


Hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...