Thanks for your help in advance I'm still very new to vba.
If I have data on sheet3 that I want to copy and paste in a specific cell on sheet1 how would I go about doing that for a specific
area of cells
Basically I need this.
if any cell in A2-33 on sheet1 equals any cell in E2-400 on sheet3 then copy whatever is in the cell next to cell E?(sheet3) in cell F?(sheet3)
and paste the value into the cell next to A?(sheet1) in cell B?(sheet1)
? being the row number where they match.
It has to be a value paste as well
so I guess something like this?
E?(sheet3)=A?(sheet1) so copy F?(sheet3) and paste value in B?(sheet1) .... but like in VBA
Thanks so much. I usually just search forums where someone is trying to do something similar and adjust their code to work for my workbook but I'm having difficulty finding something similar to this.
Is this even possible?
If I have data on sheet3 that I want to copy and paste in a specific cell on sheet1 how would I go about doing that for a specific
area of cells
Basically I need this.
if any cell in A2-33 on sheet1 equals any cell in E2-400 on sheet3 then copy whatever is in the cell next to cell E?(sheet3) in cell F?(sheet3)
and paste the value into the cell next to A?(sheet1) in cell B?(sheet1)
? being the row number where they match.
It has to be a value paste as well
so I guess something like this?
E?(sheet3)=A?(sheet1) so copy F?(sheet3) and paste value in B?(sheet1) .... but like in VBA
Thanks so much. I usually just search forums where someone is trying to do something similar and adjust their code to work for my workbook but I'm having difficulty finding something similar to this.
Is this even possible?