Using external data in Excel sheet and adding a column with a formula. I want to automatically have formula included in new rows.

Question

I have an Excel sheet that gets external data.  I added a column with formulas to perform a calculation on the data.  I then all this data (including the calculated column) in a dynamically sized data range (using the offset formula etc.).

How can I have my calculated formula be added or removed from the rows whenever I refresh the data?  I need to do this so my dynamic data range functions properly?

Answer 1

Check this link

http://office.microsoft.com/en-us/excel-help/create-or-delete-an-excel-table-previously-a-list-in-a-worksheet-HA010342376.aspx