[Solved] Separate sheet into snapshots

[BrianDP1977]

I currently have a pretty large worksheet that displays an overview of catagorized information (if that makes any sense). It's gotten kind of large and I would like to keep this sheet but also offer seperate sheets that display only certain areas from this overview sheet. I can't just copy the sheet and delete out certain areas because it would affect the output of certain cells. Is there a way to display a snapshot of the interested areas and insert it on another sheet (maintaing the automatic updates that now occur on the sheet over time)? Or, better yet is there a way to copy the large sheet and hide those areas that I don't want to show? If all else fails I'll just use a lot of =source equations. Thanks.

 

[acw]

Hi

Bit broad, but have you thought of using (a) filters to show the specific data, (b) custom views or (c) pivot tables???


Tony

 

[BrianDP1977]

Nope, not sure how to use that stuff but will look into it. Right now I'm going under format and hiding rows and columns to get something similar to what I want but not quite. In the end, I think I'll just copy the sheet, cut out what I want for each sheet and format it to work cut and paste an updated portion from the original into the copied sheets. SHould work for what I'm trying to do. Thanks for the help.