Formula or Macro to lookup values in closed spreadsheet based on description. . .

It is impossible to get values from a closed spreadsheet...However it is possible to open it, use it and close it. However to help us help you then it would be helpful if you can give us more information...
1. A template workbook that you are working with.
2. Anymore information (Not breaking confidentiality) on the folders and other workbooks locations and names.

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.

1. What column are you entering the manufacturer in?
2. What column are you entering the model in?
3. What is the path where the files are?
4. 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?
5. 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?
6. What column will be searched for the model number?
7. What column contains the cost values in the searched sheet?
8. Where column should the found cost be put in on your open workbook?
9. What if the model isn't found?

Please Login or Register  to view this content.