Hi, I’m using Excel 2010. I have a report which I need to update on a weekly basis. Each row in the spreadsheet contains one reference number and some other associated information (eg the date the ref was created, current status etc) . When I receive the weekly report, I need to update the data in the spreadsheet to show any changes in status and any new reference numbers that have been created. Rather than me examining every item to see if the data has changed, is it possible to write a formula that will look at the reference number in A1, and if that number occurs in the new report, to paste the entire row from the “new” report into the ”old” report. Then do the same with A2, then A3 etc . Also, if any new reference numbers are added these need to be added to the bottom of the spreadsheet. Is this too complicated to do using formulas or will I need to learn VB or something to do this?