Hi royUK, I have used the match & row() to find the row number of what I am looking for but want to create another worksheet that looks up the details on that row found, and if I add some details want some VBA to tell excel to paste the information at that row number instead of having to look for the details on a specific row manually.