I used the 'record new macro' function to copy data from two columns of my access database, and paste it into my spreadsheet. This works fine until I add another record, therefore meaning another field in each column. When I then run the macro, it only imports the same records as before, and does not include the new data. Any idea how to change the macro so that it includes all of the records in those two columns?