I've posted a problem re Get&Transform append. Perhaps there is a VBA solution to what I want to do. I have a source data sheet S and destination sheet D in another workbook. I want to delete the data completely in S on a daily basis and put new data in S (usually on a row or 2 per day) and then update the new data to D without deleting the previous. So S is a totally new database each day, D grows day by day and maintains all the previous data. So it cuts the rows from one range (s) which vary in number and pastes them on the next available row in D thanks