Hi David

Your data is pretty messy. A lot of cleansing/converting/formatting is required before the report could be generated.

Since your attachment did not have the Invoice No so I didn't extract it.

From what I can see, all the Invoice number is the same except the PAGE No.

The macro will clear the data from the Extract Field sheet before extracting.

For your info the original sheet name Extract Field have an extra trailing space that I have removed.

Hope this helps.

Sunny

Big help Sunny!

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 Check Worksheet, ie  base on field "Model No"?

Hi David

Don't quite understand your question.

Can you provide some example of the expected output as per your attachment.

Like in the PO Check worksheet  all fields extract there based on common field Model No

Pls use this file data instead .

There are a lot of duplicate data so I really don't know what is your expected output.

Just give me a few example of what is expected in column H (Qty)

Furthermore the Model No field have excessive trailing spaces that need to be cleaned.

Yes trailing space must remove first for Model No field preferably using Macro.

Pls refer attach file again , hopefully make my reqeust more clear to you

Hi David

Is it something like this but with a macro?

Sunny

Try this.

Yes, Sunny exactly the idea, ie using Extract Data Sheet then base Model No.  if match,  then  get follow Fields record ] but using Macro

Tks Sunny , but I need the PO No fiield as well ..

Pls help ..

Sunny, pls refer this attached for the desired outcome...

Give this a try