Need some help eliminating used element from a huge list & retain only unused ones.
I have attached a spreadsheet file. It contains 2 sheets:
-
Master Sheet - contains Element Number [Column A] & Number of each Element [Column B]
-
Subset Sheet - contains Elements used [Column B] & Quantity used [Column D]
How can I create a new sheet, that is a copy of the Master Sheet, that has eliminated the elements that have been included in Subset Sheet?
For example, the Master List contains 12 Nos. of the Element 05-10000 [A4, B4]. The Subset indicates that 7 Nos. of 05-10000 [B2, D2] have been utilized.
Therefore, I would like the new sheet to indicate that 5 Nos. of Element 05-10000 remain.
Additionally, the Subset sheet indicates that 1 Nos. of element 05-10100 was used. Therefore, the new sheet must indicate that 0 Nos. of 05-10100 remain.
Do note that the Element Numbers in the Subset are not arranged in sequential order.
Alternately, it is also fine, if the balance quantity can be displayed in a new column of the Master Sheet itself.