K
Kerry
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
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