Hi Guys,
I'm new here. I've seen the posts and am confident that I'll find my solution here.
I've been tasked to translate data from user inputs into a table.
The user inputs are fixed and cannot be changed (Because it will disrupt the users workflow)
To ask.JPG
The bigger green box is a drop-down lists. The Red boxes are user inputs. This data entry form is a way for us to track defect types from our raw materials.
How it works
Our guys would enter the material number and the batch number at the left-most red rectangle,
then they would choose, from a drop-down list, the material type (Big green box) which would dictate the defect type that are available to them (small green box & also a drop)
And then they would enter the quantity of defected raw material that share the same defect at the bottom (red rectangle)
My task
I need to break it down on another tab so that it looks like this:
End Goal.JPG
Its something along the lines of transposing, but not quite as its not a perfect array.
I'm not sure of SUMPRODUCT would do the trick and my only experience with VBA is the record function...
Any help would be greatly greatly appreciated!
Bookmarks