Hello,
Thank you for tacking your time to help me out.
I have in one sheet a list of hardware (Bolts, washers, Nuts, Rods, etc.) and I want to make kits in other sheet.
For example:
I have in one sheet 10 1" x 2 1/1" Bolt, 10 1"Flat Wahers & 10 1"Nut and I want to chane it to 10 1" x 2 1/1" Bolt, (1) flat washer, (1) Nut.
The (1) indicates that is only one per bolt. If there where 10 bolts, 20 washers and 20 Nuts they would have (2).
In the list there could be different bolts (Diam and/or length)
Here are 2 images of I want to do:
INPUT
https://dl.dropboxusercontent.com/u/25668172/Kit.JPG
RESULT
https://dl.dropboxusercontent.com/u/25668172/EMR.JPG
Thank you in advance!
Thank you for tacking your time to help me out.
I have in one sheet a list of hardware (Bolts, washers, Nuts, Rods, etc.) and I want to make kits in other sheet.
For example:
I have in one sheet 10 1" x 2 1/1" Bolt, 10 1"Flat Wahers & 10 1"Nut and I want to chane it to 10 1" x 2 1/1" Bolt, (1) flat washer, (1) Nut.
The (1) indicates that is only one per bolt. If there where 10 bolts, 20 washers and 20 Nuts they would have (2).
In the list there could be different bolts (Diam and/or length)
Here are 2 images of I want to do:
INPUT
https://dl.dropboxusercontent.com/u/25668172/Kit.JPG
RESULT
https://dl.dropboxusercontent.com/u/25668172/EMR.JPG
Thank you in advance!