<div>
If the Sub Total fields are hidden you can create a Named Range for the row/fields that contains the sub totals. &nbsp;Hide the row and then you can access the Named Range directly by typing it into the cell name box. &nbsp;This will activate the named range and then do a copy and paste.<br />
<br />
Or do you want a VBA macro solution?
</div>


If the Sub Total fields are hidden you can create a Named Range for the row/fields that contains the sub totals.  Hide the row and then you can access the Named Range directly by typing it into the cell name box.  This will activate the named range and then do a copy and paste.

Or do you want a VBA macro solution?

<div>
Topio: I'm working with your solution, haven't been able to execute as there is other data in other columns that has to remain in sync with the sub total rows...<br />
thanks<br />
<br />
A macro solution will do..thanks
</div>


Topio: I'm working with your solution, haven't been able to execute as there is other data in other columns that has to remain in sync with the sub total rows...
thanks

A macro solution will do..thanks

<div>
Forced accept.<br />
<br />
Computer101<br />
EE Admin
</div>


<div>
An easier solution here is to highlight the subtotals go to EDIT, GO TO, SPECIAL, VISIBLE CELLS ONLY, OK. &nbsp;This will highlight just the subtotals and now you can copy and paste it anywhere you want. &nbsp;Remember to do a PASTE SPECIAL, VALUES so the formulas don't follow you.
</div>


An easier solution here is to highlight the subtotals go to EDIT, GO TO, SPECIAL, VISIBLE CELLS ONLY, OK.  This will highlight just the subtotals and now you can copy and paste it anywhere you want.  Remember to do a PASTE SPECIAL, VALUES so the formulas don't follow you.

<div>
<div class="content wysiwyg-content">
Hello, I'm using MS Excel and have a series of subtotal in columns, I have hidden the numbers that sums up to the subtotal and now I want to copy just the subtotals to aanother spread. How can I copy the subtotal without the hidden details...both are in the same column
</div>
</div>


Hello, I'm using MS Excel and have a series of subtotal in columns, I have hidden the numbers that sums up to the subtotal and now I want to copy just the subtotals to aanother spread. How can I copy the subtotal without the hidden details...both are in the same column

Excluding hidden cells in Excel with the copy command

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.