Hi,

Sorry this is hard for me to explain simply so please stick with me and ask questions where needed:

This is what I'm trying to achieve:

If D84 on Sheet New = a Cell in Column C on sheet current

Then Copy A,B,C,D,E,F,G,H on that row where the match is true on sheet Current, to D9,E9,F9,E15,E17,E11,E12,E13, on sheet new.

Now this is all new to me and I have been trying to work on it in baby steps but I need help to learn how to do it so this is what I have:

Sub Recall()
Dim ws As Worksheet
Dim I As Long

  Set ws = Worksheets("Current")
  With Worksheets("New")
   l = Application.WorksheetFunction.Match(("D84"), ws.Range("A:AAA"), 0)
    MsgBox "Found" & l
  

End Sub
As you can see, what I am trying to do is get a basic Match to happen and a Massage box to open up. (With help from Google) but it dosn't work and I have no idea what I'm doing wrong and how to fix it following that I have no idea how to add the copy function.

As I said I'm very new to this I have experience at a basic level with Macros from an early age.

If this can't be done please tell me and I will try and work out a work-around but I am sure it will is I just can't work it out.

Thank everyone for your help

Regards

Rich