View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nelson Nelson is offline
external usenet poster
 
Posts: 69
Default Main data sheet convert to high level

I have a data sheet that pulls all data I need, trouble is the same company
can have multiple enties


Now I want to create a clean high level sheet, using the customer ID number
pull the customers name, customer number and add up the customers costs into
one cell for each year 2008,2009.

So I would then see in Cells A1 - D1

Customer name - Number - Maint paid 2008 - maint paid 2009

Can this be done?


--
Nelson