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?