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.
Maybe:
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
I'm getting an error since I have data in column C also.
I just need the macro to overwrite the original QTY and then delete the "Qty. typical for #" statement.
Here's an example of the data.
j0RIU.png
In terms of the data table, the header is just from the original sheet and I don't necessarily need it to continue what I'm trying to achieve.
I'm essentially just consolidating many separate units into 1 final for a complete count of materials.
So, I wonder if I remove the header first, this would be easier to achieve.
Last edited by Anxiety; 11-19-2015 at 09:07 AM.
Please Login or Register to view this content.
I had to add
for it to skip non-numerics, but otherwise it works perfectly.Please Login or Register to view this content.
I really appreciate the help.
No problem, glad I could help out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks