Refresh table then paste that data into another tab when workbook is opened

[cmorten82]

I have an excel workbook that has a table in it. That table comes from a data connection to MS Access. I want to be able to open that workbook and have the table refresh, then I want all the data in that table to be pasted into another Tab named "Data Source". The caveat is every time the workbook is opened there will most likely be new rows of data added so I need it to either re-paste the data after deleting the existing data or have it append any new data to the existing pasted data. I assume the "delete and re-paste" option is probably the way to go but I have no idea where to begin or end.

[millz]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window (or use the paperclip icon).