Replace Table with New Data

**jomili** · 10-28-2015, 10:45 AM

I have a workbook. In Sheet1 ("Source") I have Table1. In sheet2 ("Formulas") I have various formulas that reference Table1.

On a regular basis I want to delete all of the information in Table1 and replace it with updated data. This is the start of my current code, which deletes everything under the headers and converts my table to a range:

Please Login or Register  to view this content.

I then open another workbook, gather a bunch of data, copy it, and paste it back like this:

Please Login or Register  to view this content.

My problem is my formulas. For instance, this one:

Please Login or Register  to view this content.

That's the way it starts out before I start my macro. Once I finish, the formula changes to

Please Login or Register  to view this content.

I'm thinking if I turn off Calculation that might fix that problem, but I need to calculate on my other workbook.

**jomili** · 10-30-2015, 10:12 AM

Still haven't got a response, maybe I didn't phrase it well enough. In a nutshell, I want to replace all of the data in a table with new data. My current procedures involves deleting and replacing the table, which means I also have to replace all of my formulas. I'm hoping there's a better way to replace all data in a table with new data. Please advise if you know of a way.

Thanks,
John