Agreed with @ARowbot, and this is fairly simple. I've shown you some sample code below, but if you can answer the following questions, I can tailor it to your setup.
I guessed or put in default info into the code in answer to all of these questions, so it's highly unlikely the code will work until modified to your formatting and file structure.
- What column are you entering the manufacturer in?
- What column are you entering the model in?
- What is the path where the files are?
- Do the folders the files are in, and the files themselves match exactly the manufacturer name as entered on the spreadsheet? if not, what's the delta?
- What is the sheet name that the code will search? Is that sheet name the same in every file? If not, what's the relationship between the file name and the sheet name?
- What column will be searched for the model number?
- What column contains the cost values in the searched sheet?
- Where column should the found cost be put in on your open workbook?
- What if the model isn't found?
Bookmarks