View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LC[_4_] LC[_4_] is offline
external usenet poster
 
Posts: 1
Default Creating separate sheets from a list

I have a list of transactions. I need to break this list
down by Source. Each source is a new worksheet. However,
these sheets will be in a new workbook. What is the best
way to program this?

Sample List:

Company Source Transaction
123 MAD 60,000
456 MAD 80,000
789 MAD 62,500
123 TRS 45,500
234 XYZ 12,500
456 XYZ 10,000
789 XYZ 50,000

Based on the above list, the new workbook should have 3
sheets with the corresponding sheet names: MAD, TRS and
XYZ.

thanks for your help.