candychan611
asked on
EXCAL VBA
ASKER
Thomas,
Your code only fill in IC3 , my desired result should be lookup the Sheet PI REF_NO
and Sheet PRICE REF_NO to find out the VEND_NO.
e.g. REF_NO 1002 should be 103
REF_NO 1006 should be 102 .......................... .......... .......... .......... ..
Your code only fill in IC3 , my desired result should be lookup the Sheet PI REF_NO
and Sheet PRICE REF_NO to find out the VEND_NO.
e.g. REF_NO 1002 should be 103
REF_NO 1006 should be 102 ..........................
So take the REF_NO from the selection, then look for it in the PRICE Tab, and return the VEND_NAME corresponding to the V_ITEM_NO?
ASKER
Yes right !
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thomas
Open in new window