This one component in many layers of macros for a project I'm working on.

I need a macro to search for the text "Qty. typical for #" in column A.

Then take the # and multiply by quantities in column B and Do Until IsEmpty.


' Search for "Qty. typical for #" in column A

Multiply # by column B

Until column B is empty

Any help is appreciated.