autofilter, launch action
Pardon the x-post again...felt this would be better posted here. Is there a way to do the following: Sheet 1 Column A has an autofilter. When an item is chosen, is i possible for it to trigger an action in another sheet? The action would be to find the same item in Sheet 2 Column A as man times as it occurs and then hide everything else that does not matc (by hiding the rows that the non-matching items appear in) -- spiros ----------------------------------------------------------------------- spirosu's Profile: http://www.excelforum.com/member.php...nfo&userid=744 View this thread: http://www.excelforum.com/showthread.php?threadid=52287 |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com