Import data and macro
I have a spreadsheet that uses a web query to gather data. Everyday I
refresh this query and copy and paste the date it imports into another tab.
I do not overwrite the data from previous days. I just copy and paste the
data below the previous days. Is there some way I can have excel do this
automatically? Maybe some kind of macro? Thanks.
|