Looking to Hire a Programmer for a Small Project

Hey All,

I'm looking to hire someone for a small task that I don't have the expertise to do myself. I'm going to try to explain it below, but I've attached reference files as well.

Moderators: I didn't see where requests like this weren't allowed, but if they aren't I apologize.

I'm looking to match part numbers from an external .csv file in the same directory to a master Bill of Materials (BOM) (Column A). If it finds a match, it would add the quantity listed in the csv file in a column whose heading closely matches that of the csv filename (E1-N1). If that part doesn't exist in the BOM, it would add it in a row inserted near the top with the quantity in the respective column. In the reference files, the cells that are filled with purple are the ones that have been "matched".

I'd like to see if anyone's interested in doing this and how much they'd charge for it (or you're more than welcome to be charitable - this is coming out of my own pocket). If you have any questions or need anything else, please don't hesitate to ask.

Originally Posted by tigeravatar

stusic,

Give this a try (it assumes the .csv files are in the same folder as the BOM.xlsm file):

Please Login or Register  to view this content.

I'm sorry I haven't responded to this for so long, apparently I didn't have my subscriptions set to notify me when a response had been posted. Again, apologies.

Anyways, this is crazy fast and seems to work really well, with one exception: it doesn't appear to add part numbers that are found in the csv, but not found in the BOM. Ideally, they'd be inserted after Row 9 (so no part numbers are below Row 10). Would this be a quick fix?

I really appreciate it; you've got serious skills. And a serious charitable streak

I just noticed something else as well: when a match is found, it's added to any quantity that may already be there, where it should just replace any value that's there.

So close...

I'd be glad to buy your lunch if you wouldn't mind taking a crack at just a couple things to finish this up:

Although you got it to replace values that are already present, it seems to add any unfound items to the bottom of the list, and will repeat this with each additional time the macro is run.

When it adds items from the csv file to the BOM, it's adding a few columns that aren't required (Column A). I also need it to multiply Columns E & F to get the total quantity that goes on the BOM. I was going to change the Autolisp code that generates the csv to do this automatically, but discovered I need to keep it the way it is, so I need the macro to do this. The columns should match up as follows (basically not using column A of the csv file): csv B - bom A, csv C - bom B, csv D - bom C, then the product of csv columns E & F to the respective quantity column of the bom.

Now you're beginning to understand why I was willing to pay someone. Seriously, PM me your email and I'll see about getting you a Fudrucker's card or something. Thanks so much for your help, this is going to save me and my department soooo much time. The previous macro that did this is ridiculous and the guy who wrote it isn't even here anymore.

Okay, everything seems to be working well except for the multiplication of the "Count" and "Quantity" values from the csv file. Looking at the code, it seems the code below never evaluates to True, so it never gets to the second bit of code. Couldn't figure it out though.

Please Login or Register  to view this content.

Please Login or Register  to view this content.