Translating Info to Bill of Materials

[zachdssi]

I don't know if this is the right place to go for my particular problem, but might as well start somewhere.
I'm trying to make a Bill of Materials setup where all I would have to do is type in the part number and the rest of the non-variable information would instantly be filled in based on that part number I typed in. I understand that I would have to have an inventory sheet of sorts so that Excel would know where to pull the information from, I'm just wondering if there would be any way to do what I'm wanting. Any help would be appreciated.

[ranman256]

This is more of an Access database thing.
Access can store lots of parts and their Bill of Mat. lists related to 1 part#.

Excel can do single part lookups but not groups of parts. Not without lots of code.
I have built 'Bill of Mat.' apps in Access before. This is the needed software for your requirement.

[newdoverman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[FDibbins]

Agtree that seeing what you are working with, would be a great help. Take a look at using VLOOKUP() or INDEX/MATCH for this