Extract numeric value from string, and multiply by parts Qty

So, I've come across an issue with a template I've been working on for engineers.
The template simply consolidates all their parts across many sheets into one sheet.
So far the parts count is working wonderfully (mostly thanks to the people on this forum).
The macro set works primarily because they have specific standards of operation, however, all engineers do one thing differently.

They will note if a parts list is typical (for more than one unit) and note it differently (see example excel).

I'm not sure if there's a way to dynamically search for something that contains "typ" in column A, but I think that is the right direction.
The last listed example shows how they will list two specific units, but only list the parts for one unit, I can get them to change that standard if it can't be coded to adapt to that.

Primarily they will type "Typical for #", and I had a macro for that, but there are too many different engineers with different methods of annotating it.

Example 2.xlsx

See if this is what you wanted.
Not sure about your result for last 2 items.

Please Login or Register  to view this content.

If you upload a workbook clearly showing possible combination of the data and exact desired results, it may help to understand what you are trying to do.

It works well, but unfortunately it will multiply any number in column A above the table.

Is there a way to skip the math by asking only if it says "Typ" or "Typical" in the string?


In my example worksheet, on the After sheet, the last table should not change, but with your code, it does.

Thanks.

Example 2.xlsx

Change to

Please Login or Register  to view this content.

Works perfectly, thanks very much.

You are welcome.