I have set a datamacro to do this but as it is over 7,000 records I wish to append from one table/list to the next, it times out and cancels the macro. Any suggestions? I really do not want to have to copy and paste from one datasheet to the next as I understand there are limitations to the amount of data that can be copied each time as well.