Combining alike cells?
 

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?

Combining alike cells?
 

Your request seems like a good candidate for a pivot table if you data is
structured correctly.

I would suggest you start with column headings of 'Customer,' 'Product,'
'Qty,' 'Amount,' and 'Date.' You could then create a pivot table to assist
in displaying and analyzing your data by customer, date, or product, just to
name a few. As you get more experienced you can group this information by
customer type, or product category, etc. Pivot tables even have decent
graphing capabilities for trend analysis. You can find a lot of information
in EXCEL's help feature , or on the internet.
--
T Tipsy


"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?

Combining alike cells?
 

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?