I have built a macro that imports data from a csv file to a specific worksheet tab. The macro works well with only one small problem. The old data needs to go away and replaced by the new data in the CSV file. Currently when I refresh the import, the old data is shifted to the right and the new data goes in to the old columns on the left.
Is there a flag in the Import connection properties that will let you overwrite the old data and have the data areas shrink or expand as needed? Or do I just need to do a simple copy and paste of the data?