Copy If Match a cell contents

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:

Please Login or Register  to view this content.

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

Can anyone help with this?

hi i was having a quick look at this before i left work for the day yesterday

before i continue when you match the data and copy it to the sheet is it a once off thing? so what i mean by that is that do you wish to keep a record of the things you've matched? or is it to be refreshed when you enter a new number in D84?

i dont think you will need vba code rather =Index,Match

Example attached

indexmatchsample.xlsm

enable macros

Thank you for your Help gwsampso, but not quite what I was looking for, I had a bit of help but just incase anyone else comes up with this same probleam here is what I used for a guide

Please Login or Register  to view this content.

Rich