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? |
All times are GMT +1. The time now is 03:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com