software

I received an excel file with subtotals among groups of items. How do I
extract only the sku#, description and total qty as a single row. I
would like to sort the data etc. -------------------------------------------------------------------
Filename: DHN sales mix.zip
Download: www.excelforum.com/attachment.php?postid=4384
-------------------------------------------------------------------

--
nander
------------------------------------------------------------------------
nander's Profile: www.excelforum.com/member.php...foamp;userid=6156
View this thread: www.excelforum.com/showthread...hreadid=514911Use a backup of course to try this to remove Subtotals.........

Highlight a cell in the field, then Data gt; Subtotals gt; Remove All

Vaya con Dios,
Chuck, CABGx3
quot;nanderquot; wrote:

gt;
gt; I received an excel file with subtotals among groups of items. How do I
gt; extract only the sku#, description and total qty as a single row. I
gt; would like to sort the data etc.
gt;
gt;
gt; -------------------------------------------------------------------
gt; Filename: DHN sales mix.zip
gt; Download: www.excelforum.com/attachment.php?postid=4384
gt; -------------------------------------------------------------------
gt;
gt; --
gt; nander
gt; ------------------------------------------------------------------------
gt; nander's Profile: www.excelforum.com/member.php...foamp;userid=6156
gt; View this thread: www.excelforum.com/showthread...hreadid=514911
gt;
gt;