Hi

I think Bill is suggesting (quite correctly) that it is best to do
everything on the source sheet - Sheet1 - and that you should avoid copying
data to other sheets for creating different views.

Yes, by all means sort your data by Director then ViewsCustomAdd and give
it a name. Repeat this for the other views you want.
Then use ViewsCustomShow to display the relevant report.

Or, you could record a macro as you carry out the sort each time, even
hiding certain columns if required. You could then allocate these macros to
buttons on the sheet rather than using views.

Regards

Roger Govier


wrote:
Bill,

Can't the views use the same data, thus displaying any changes in any
of the views?

Steven