Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Custom Views
Hi,
I have a an Excel File with data that is shared by different departments. All data is stored on the first worksheet. I then set up Custom Views so that it would display the relevant information for each specific department depending on which view was selected. Now what I would like to do is have each view on a seperate worksheet - each worksheet obtaining their data from the first worksheet. When ever the first worksheet is updated (with new details), then this update reflects on all of the other worksheets. Anyone know if this is possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get custom views created in Excel 2K to show in Excel 200 | Excel Worksheet Functions | |||
Custom Views Dropdown List | Excel Discussion (Misc queries) | |||
Custom Views in Shared workbook | Excel Discussion (Misc queries) | |||
Custom Views in Pivot Table | Excel Discussion (Misc queries) | |||
Can I set my custom views on Pivot table | Excel Discussion (Misc queries) |