Using Match and Address within Macro/VBA

[hthoma11]

I have 2 worksheets "Data" and "P558 Main FE Defects"

In "Data" I want to be able to click a button and paste "E46" into the correct location in "P558 Main FE Defects". I am able to find the value of a given cell with this formula, but what I am needing is the address so I know where to copy and paste "E46" to. Here is the formula that gives me the value of the cell...

=INDEX('P558 Main FE Defects'!B2:AF45,MATCH(Data!D2,'P558 Main FE Defects'!A2:A45,0),MATCH(Data!A2,'P558 Main FE Defects'!B1:AF1,0))

Once I find the address of this cell I want to paste the value of "Data!E46" into this location. I am somewhat new to VBA/Macros and was wondering if anyone could help? Please let me know if I need to further explain what I am needing.

NOTE: The information shown in "Data" is always changing. They are all drop downs except "Qty"(Column E), this is manually typed in.

 

[Nebu]

Hi:

One way of doing this is using find method in VBA. If you want someone to code this for you please upload a sample file here.

Thanks