Last seen: Jan 7, 2025
Sunny, pls refer this attached for the desired outcome...
Tks Sunny , but I need the PO No fiield as well .. Pls help ..
Yes, Sunny exactly the idea, ie using Extract Data Sheet then base Model No. if match, then get follow Fields record ] but using Macro P/O...
Yes trailing space must remove first for Model No field preferably using Macro. Pls refer attach file again , hopefully make my reqeust more clear ...
Pls use this file data instead .
Like in the PO Check worksheet all fields extract there based on common field Model No P/O No. P/O Item No. Model No P/O QTY Receiv...
After data Extract, can we develop the Macro further to compare and contrast to the PO data in the Master Sheet and extract the required fields in PO ...
Big help Sunny!
Tks Sunny, sorry the intruption..
Pls help modified the VB
Yes, got it , thanks Sunny.
Yes it works, but how to group by month summary ?