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
Bookmarks