Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering in Excel
I have created a database in Excel 2003 of organisations that provide
services. I have the list of organisations on sheet 2 with column headings of name, address, phone number and ten other columns that have the name of a service type ie respite, accommodation etc. On sheet 1 I have created corresponding buttons that have macros attached. When you click on a button it goes to sheet 2 and using the columns with the service types filters out the organisations that don't provide that service. At the bottom of each column there is another button that unfilters and takes the user back to sheet 1. If the user doesn't use the back button but clicks on the sheet 1 tab it doesn't unfilter and this creates a problem for the next user. Is there a way to automatically unfilter when you click on the sheet 1 tab. Thanks, Kerry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering by criteria within PV in Excel. | Excel Discussion (Misc queries) | |||
EXCEL FILTERING | Excel Discussion (Misc queries) | |||
Excel Filtering | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
excel filtering | Excel Discussion (Misc queries) |