Copy a range in Next row (with changing timestamp)

It really would be more efficient to modify your query code so that after it refreshes, it just copies row 2 to the next available row. But maybe it can also be done with w worksheet_Change event code. Copy this to the sheet code module for the sheet where the refresh takes place.

Please Login or Register  to view this content.

A potential problem would be that it copies for each cell in columns B:F.I don't know how your Query code is written to populate those cells on a refresh. If they are all populated simutaneously, no problem, but if they are populated consecutively then you might get multiple pastings of the same data on your sheet. Like I said, the ideal way would be to have the code that does the refresh modified to also do the copy and paste.