Hi,
I am building a document to calculate weights of suitcase for travel.
On each row of my spreadsheet I have:
Combo Box with the different suitcases listed.
A check box next on each row to be checked by the user once an item has been packed.
A column for the weight of each item
I have a small table in which each suitcase is listed that will show the total weight of each case.
What I want to happen is the user will select which suitcase a particular item is going into from the Combo Box and then click the check box for packed.
Once the check box has been clicked the weight of the item on that row will be added to the total weight of the suitcase selected in the combo box.
Please see the sheet attached
Bookmarks