[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.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,628
Messages
5,832,762
Members
430,165
Latest member
Idjaz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top