LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating separate graphs for columns of data MelissaAnn72 Charts and Charting in Excel 1 April 27th 10 03:19 AM
Creating a Separate Chart for Each Row of Data HobieJuan Charts and Charting in Excel 4 July 21st 09 02:14 PM
List and subtotal selected items, then print separate item list TitanG Excel Worksheet Functions 0 September 8th 08 09:07 PM
Creating Sheets from a List Mike Armstrong Excel Discussion (Misc queries) 8 December 8th 06 04:00 PM
Creating separate reports for each Project Manager Lorie Excel Discussion (Misc queries) 4 June 15th 05 02:26 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"