Hey everyone,

I am new to visual basic and I have been trying to figure something out for a while now. Pretty much, I need to create a macro in excel that will search a different excel file for anything that matches a certain criteria, copies whatever the value is in the column c, and paste it back into the original excel file. I have to do this for several items, but if I get the first item down, I think I can figure it out for the rest of them. Anyways, here is an example:

I have item number 5202001. So the macro searches the other excel file for 5202001, but this item must meet certain criteria (this criteria will be the same for every item.) The criteria is that whatever is in cell B must equal CTD or HQ. Whatever is in cell I must be equal to CTDRM.


The macro will find an item that matches this criteria, it copies the value in cell C, which is a quantity, and then pastes it back in the original excel file in cell E38.

Thanks for any help you can give me, I am so lost right now and I have been trying to figure this out on my own for about 2 weeks now.