[Solved] Separate sheet into snapshots

BrianDP1977

Board Regular
Joined
Nov 5, 2005
Messages
146
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.
 

Some videos you may like

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

acw

MrExcel MVP
Joined
Feb 13, 2004
Messages
4,814
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

Board Regular
Joined
Nov 5, 2005
Messages
146
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,269
Messages
5,577,108
Members
412,768
Latest member
klig
Top