Ok after some research (thanks for your pointers) I have some sucess but also another error.
I followed the directions here: http://chandoo.org/forums/topic/how-do-i-consolidate-several-tables-in-one-long-table#post-11733
While the file remains open everything works well. However, once I...
I'm having problems working with some external data in my excel document. All of the raw data is located in some reports that are saved as html so I import that into my workbook then I have a table on another sheet that performs all the calculations needed.
My problem is that when using the...