In my workbook, one tab ( SOA ) contains a lot of inventory. The next tab
( SOA_2 )contains a database extraction and displays only those records from SOA with " units > 0 ". The macro that does the extraction is now triggered by clicking on a button. This all works fine, but ... It would be a little more " idiot proof " if the extraction macro could be triggered every time the SOA_2 tab is selected. Can this be set up? If so, How?
Thanks in advance for any help with this.
Regards,
Vernon
( SOA_2 )contains a database extraction and displays only those records from SOA with " units > 0 ". The macro that does the extraction is now triggered by clicking on a button. This all works fine, but ... It would be a little more " idiot proof " if the extraction macro could be triggered every time the SOA_2 tab is selected. Can this be set up? If so, How?
Thanks in advance for any help with this.
Regards,
Vernon