I have a spreadsheet in which column A has customers' names and other columns
have other info. Some customers have only 1 row worth of info, while others
have several rows (all directly below each other). I would like to be able to
double click the customer's name and if there are multiple rows for this
customer (meaning there is no customer name directly below, but rather a few
rows down), it will hide the rows below until the next customer's name. And
another double click will unhide the rows. For example, A1 will have "Smith".
A4 will have "Johnson". A5 will have "Brown". A9 will have "Davis". If I
double click A1 it will hide rows 2-3. If I double click A5, it will hide
rows 6-8.

If anyone can help me I would be very grateful.
Thanks, Scott