How to create a button that copies a ranges of cells in one spreadsheet, then copies that data to another spreadsheet, appending what is already there.
Posted on 2014-09-18
I have two spreadsheets. One spreadsheet has a range of data. It is an ODBC query into a SQL database. I pull that data, modify the data and print it. Well, as you know, the next time i refresh the data, the changes i made to the query will be erased. I am looking for a way when I refresh the query, i make my changes, then click a button or something that copies all the data onto a totally different spreadsheet. Then, the next week, or whenevere i open the query, i can refresh the data, then click this button, then it copes and ADDS TO the other spreadsheet. So basically this 2nd spreadsheet just keeps getting added to. Is it possible to do something like this? If so, is there a macro that would do this? Thanks!!