PC Review


Reply
Thread Tools Rate Thread

Creating summary table from detail table

 
 
RzB
Guest
Posts: n/a
 
      16th Sep 2006
Using Win XP and Excel 2002

This is a simplification of a problem that I'm trying to solve...

I have a Detail Table as shown in ...

www.gillandroy.com/odds/excel/summarytable

from this table I want to create a Summary Table - also shown
in the above link.

The Detail Table is actually created line by line from some
Access VBA and can contain a variable numbers of lines.
There may be a varying number of distinct instances of text in
the first column, hence a varying number of lines in the Summary
Table.

I was hoping to use the internal power of Excel to create the
Summary Table. Is this going to be possible or am I going to
have to do this from the Access VBA?

Many thanks,
Roy





 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating summary table agbiggs@hotmail.com Microsoft Excel Discussion 9 12th May 2010 02:55 PM
How can I detail Pivot Table data without creating a table (Excel2007) Skeletiko Microsoft Excel Misc 1 5th May 2010 08:22 AM
How can I detail Pivot Table data without creating a table (Excel2007) Skeletiko Microsoft Excel Misc 0 5th May 2010 12:21 AM
How can I detail Pivot Table data without creating a table (Excel2007)? Skeletiko Microsoft Excel Discussion 0 15th Apr 2010 11:56 AM
Creating summary table from detail table RzB Microsoft Excel Worksheet Functions 4 18th Sep 2006 08:57 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:42 PM.