I hope you can help me with this as I have scoured the Internet and can't find a solution.
I have a mastersheet of parts. I want to put in quantities required against certain parts. Then I want my subsheet to populate only with parts from the master sheet that have values greater than 0. I don't want to see any other parts on the subsheet.
Example of Master Sheet:
PartNumber PartName NumberRequired
1 Wheel 1
2 Bumper 0
3 Mirror 1
4 Glass Window 0
I want my subsheet to display only parts where the number required is greater than 0, so the subsheet would look like this:
PartNumber PartName NumberRequired
1 Wheel 1
3 Mirror 1