I'm not sure exactly what you're trying to say.Because some of what you're
describing doesn't match up with the sample file you provided.
However, I THINK the problem is that in your original macro, you copied columns
A,B and Cand called them "Part Number", "Qty" and "VALUE" essentially, you
Hi,
The macro is close to expectation but still need fix.
Total Quantity as per data sheet(Sheet 1) is matching with "results" sheet
..
But, *total value* as per data sheet (Sheet 1) is not matching with but the
value captured by macro is not correct.
Guess the price pulled by macro is first