Looking to develop a Macro or Formula to Simplify Daily Process

[AbrahamRunning]

I get Lists of Client names daily that I need to sift through to simplify. I spend a good amount of time doing this daily. I would much appreciate some pointers on how to simplify the process. I initially sort by Term to find items that match the criteria 1030-1060, for the purpose of simplification only 1030 is included in the sample sheets. If any of that criteria match I add a '10' next to the product requested. After this I match up the products ordered by the clients and delete the extra rows. Is there anything that would do this automatically? Sample Files are attached. Thanks.

[JBeaucaire]

Why is it AB310, AB4 and not AB310, AB410?


And won't the Customer number be different for each person? That's easier to match by than trying to combine the firstname and lastname.

[AbrahamRunning]

Sorry about that, Only some of the products get the "10" . Yeah they do have individual Customer numbers I usually sort by address 1 to get the products going to each indiviual address, it also helps in pushing the PO Boxes towards the end of the list since those cannot ship UPS.

if d4 equals ab3 and z4 is between 1030-60 then add "10" after the AB3.

but then I don't know how to write the function for it.

[JBeaucaire]

So, just to emphasize, only product code AB3 gets turned into AB310? And even then only when column Z is 1030-1060?

BTW, you do know the column Z values are text, not numbers?

[JBeaucaire]

Give this a try on a copy of your sheet:

Please Login or Register  to view this content.

[AbrahamRunning]

This looks beautiful. I haven't had a chance to test it yet. I will do so in the morning with the new list. How would I add more products that fall under the criteria for adding the "10"

would I add that here:

"If Cells(i, Prod) = "AB3" Then Cells(i, Prod) = "AB310""

[JBeaucaire]

Here, I've added an array of MyStrings at the top, just put in all the strings you want to add "10" to when they match the 1030-1060 Term.

Please Login or Register  to view this content.