How to remove Subtotals
 

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: http://www.excelforum.com/attachment.php?postid=4384 |
+-------------------------------------------------------------------+

--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=514911

How to remove Subtotals
 

Use a backup of course to try this to remove Subtotals.........

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

Vaya con Dios,
Chuck, CABGx3



"nander" wrote:


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: http://www.excelforum.com/attachment.php?postid=4384 |
+-------------------------------------------------------------------+

--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=514911