View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Randy Harmelink Randy  Harmelink is offline
external usenet poster
 
Posts: 122
Default Excel - Extract data from one worksheet to many spreadsheets ...

If I understand your data correctly, I think all you want to do is
create a pivot table of the data, using cost centre and course title as
your row key fields.