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;
- Jul 16 Mon 2007 20:38
How to remove Subtotals
close
全站熱搜
留言列表
發表留言