software

I have an excel sheet with a list of columns and several rows that I
want to be able to separate the ones that are alike then total the
output.

How can I do this with a macro that can be used after the user selects
the list the macro will run a report and count.

Please see attached zip that shows the data in the excel sheet...then
what I mean by the report.

Thanks hope you can help - j -------------------------------------------------------------------
|Filename: TOTAL per order and type.zip |
|Download: www.excelforum.com/attachment.php?postid=4771 |
-------------------------------------------------------------------

--
jelost
------------------------------------------------------------------------
jelost's Profile: www.excelforum.com/member.php...oamp;userid=34499
View this thread: www.excelforum.com/showthread...hreadid=542663jelost wrote:
gt; I have an excel sheet with a list of columns and several rows that I
gt; want to be able to separate the ones that are alike then total the
gt; output.
gt;
gt; How can I do this with a macro that can be used after the user selects
gt; the list the macro will run a report and count.
gt;
gt; Please see attached zip that shows the data in the excel sheet...then
gt; what I mean by the report.
gt;
gt; Thanks hope you can help - j
gt;
gt;
gt; -------------------------------------------------------------------
gt;gt; Filename: TOTAL per order and type.zip |
gt;gt; Download: www.excelforum.com/attachment.php?postid=4771 |
gt; -------------------------------------------------------------------

I get the message quot;Invalid Attachment specified. If you followed a valid
link, please notify the administratorquot;
In MS Newsgroups try following the thread link:

View this thread: www.excelforum.com/showthread...hreadid=542663

and then follow the download link in Excelforum

--
HTH

Sandy
In Perth, the ancient capital of ScotlandReplace @mailinator.com with @tiscali.co.ukquot;Paul Lautmanquot; gt; wrote in message
...
gt; jelost wrote:
gt;gt; I have an excel sheet with a list of columns and several rows that I
gt;gt; want to be able to separate the ones that are alike then total the
gt;gt; output.
gt;gt;
gt;gt; How can I do this with a macro that can be used after the user selects
gt;gt; the list the macro will run a report and count.
gt;gt;
gt;gt; Please see attached zip that shows the data in the excel sheet...then
gt;gt; what I mean by the report.
gt;gt;
gt;gt; Thanks hope you can help - j
gt;gt;
gt;gt;
gt;gt; -------------------------------------------------------------------
gt;gt;gt; Filename: TOTAL per order and type.zip |
gt;gt;gt; Download: www.excelforum.com/attachment.php?postid=4771 |
gt;gt; -------------------------------------------------------------------
gt;
gt; I get the message quot;Invalid Attachment specified. If you followed a valid
gt; link, please notify the administratorquot;
gt;

I wouldn't think you'd need a macro. A Pivot table should do. See
attached file.

If you need the labels as in the .doc file, then let me know and I'll
give you my quot;Propogate Dataquot; macro which will achive that.

Enjoy -------------------------------------------------------------------
|Filename: Copy of exampleexcel.zip |
|Download: www.excelforum.com/attachment.php?postid=4774 |
-------------------------------------------------------------------

--
CaptainP
------------------------------------------------------------------------
CaptainP's Profile: www.excelforum.com/member.php...oamp;userid=34520
View this thread: www.excelforum.com/showthread...hreadid=542663