Calculating weight

Hey guys,

So I'm still on this darned project!

This is the last step, however, so hopefully you can help!

Basically, we're getting a spreadsheet with orders on them.
There are only 3 or 4 different items, and I want to be able to calculate the weight of them automatically.

So in English, I want to write something such as:

Please Login or Register  to view this content.

And also make it add up, so that if the value of the field is "Scarf, Scarf, Hat" then it'll put (600+600+400 = 1600) 1600g in the field.


For some sample data, this is made up and not extracted from my document, but is almost identical:

Please Login or Register  to view this content.

AFTER MACRO:

Please Login or Register  to view this content.

Cheers guys!
Br0die

Hi

And you get the weight of the items from where?????

rylo

Hey mate,

The weight of the items are unavailable to me as of yet, as we don't have the stock.

However, I was hoping that I could just manipulate the portion of the script that defines the weights.

The scarf and hat weights provided are just dummy sample data.

So essentially, the weights will need to be in the script, not pulled from anywhere.

Hope that helps!

Cheers,
Br0die

Hi

Or being a bit more generic with the items

Please Login or Register  to view this content.

rylo