Bored at work? Make some nuz...
DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact | Forum

Append Tables

View: New views
3 Messages — Rating Filter:   Alert me  

Append Tables

by BudgetMan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

I am trying to combine several worksheets together into one.  I just want to append them, one after the other into one worksheet. When I do that, it leaves the formulas so the numbers are incorrect. Is there a way to do this but have it copy as values instead of leaving the formulas?

Re: Append Tables

by DigDB Support :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

You can make a copy of your file, and then convert the entire file to value only, then do the operation. The convert a file to value-only (no formulas) demo is here: http://www.digdb.com/excel_add_ins/convert_range_sheet_file_value/

Re: Append Tables

by BudgetMan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

The solution worked great! Thank you very much!!


Features | Testimonial | Download | Purchase | FAQ | License | Contact | Forum (powered by Nabble's free forum)

Copyright © 2006 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.