Hi, I'd like to use Calc as a simple database. I've had a go with OOo.Base and couldn't do what I wanted there and wondered if it was possible with Calc. My data is very simple - it started out as a simple spreadsheet anyway. What I want to do is have several sheets which present filtered versions of the main sheet. I believe that Filters can achieve the end result, but I'd like to just switch between the 'full' view and a 'filtered' view by clicking on the Sheet tabs. Any changes to the 'full' sheet should be reflected in the 'filtered' sheet(s). Is this sort of thing possible?
The data is just a list of membership details. One example would be to have a sheet showing all UK members, and another showing non-UK members. There is a column in the data which contgains the country if non-UK and is blank for UK members. Many thanks Bill -- +---------------------------------------+ | Bill Purvis, Amateur Mathematician | | email: [EMAIL PROTECTED] | | http://bil.members.beeb.net | +---------------------------------------+ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
