I'm hoping someone can help. I have a list of unpaid invoices that I retrieve a few times a week. The raw data is pasted on one sheet (invoice data) and data from a select few columns copied to another sheet with a very simple ='invoice data'A1 formula etc. That data is then manipulated in its current position but there is no absolute link to the specific invoice data so any formulas are just to the row the invoice data is currently in. Problem is when new raw data is pasted the row position of the invoices will change as old ones go and new are added but the entries relative to a specific invoice (expected days payment is delayed, likely paid value etc) will now align with a different invoice number. Any ideas how could I overcome this?