I have a fairly large spreadsheet to list customer details which is sorted by sales reps (about 40 reps). I want to be able to double click on a rep's name and have VBA automatically group the rows with his name; then double click on the next rep and group, etc. The reps' names are always in column C.
Any advise/guidance would be appreciated.
Any advise/guidance would be appreciated.