You can easily Filter for customer names with DataFilterAutofilter

Don't know if that will help but give it a try.


Gord Dibben MS Excel MVP

On Tue, 14 Aug 2007 14:10:01 -0700, HoganD87
wrote:

For my job I am trying to make a spreadsheed that will be used and updated
over the next couple of years. It will be a document of differant customers
and products we have sold. The Y axis will contain Customers the product sold
while the X axis will be the dates. Is there something I can do to click a
cell with a customers name and it highlights or shows every time their name
was placed in the spreadsheet?