I wrote a macro to report the data.
Take a look at the attached file and see if you can follow along.
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you
Hi,
Thanks for looking at my query.
Background (Why the data is scattered) : Data are shared by multiple team
(18-20) and after consolidation it becomes a table where Part Number , Qty
, Price and Value are repeated 18-20 times. - Example refer Sheet 1
attached of raw data.
Desired output is
Without seeing your actual workbook, I'm only guessing.
What do you mean by the code "not giving desired output"?
I created a workbook with two sheets called "Sheet1" and "Sheet2".
In Sheet1 I put several column headings and made three of them equivalent
to:Part NumberQtyValue
I noticed that in yo
