Hello,
I'm trying to create a macro that gives me a vendor number from another worksheet. Below is the formula that I'm currently using. I'm using this formula for about 230 rows My file is pretty big and I'm basically trying to make it smaller by creating macros, which I'm not very good at.
ESTDATA is a worksheet within my workbook.
Can someone help me figure out how to make the function below work in VBA? I would greatly appreciate it. I've spent about 2 hours trying to figure it out. If you guys could help me paste the values at the end, that would be even better!
My formula: {=(INDEX(ESTDATA!$P:$P,MATCH($A5,IF(ESTDATA!$P:$P<>"",IF(ESTDATA!$P:$P<>"No Vendor",IF(ESTDATA!$P:$P<>"BUDGT",IF(ESTDATA!$P:$P<>"00000",ESTDATA!$J:$J),IF(ESTDATA!$P:$P<>"GENER",,0)))))))}
Bookmarks