there are various ways and means of achieving this depending on your data and the set up ect. Why dont you upload a sample? create one workbook containing old data new data and how u want the merged data to appear.