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!!
LightInTheBox - Buy quality products at wholesale price