Searchable MS database

[Ztcollins]

First I would like to thank everyone in advance for your help.

My question is can you take a linked database on one sheet of a workbook, and have the data fill into cells by a search function?

Example:
UOM = Unit of Measure


If i have a materiel part from a lumber company::: 2x4x16 Douglas Fir (Item Name), 2416F (Item Part #), EA (Item UOM)

I would have data in one cell that would be Takeoff data: IE (200 LF) then in another cell i would have a formula to take the takeoff data and create a total. (all this i can do)

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Takeoff Data[/TD]
[TD]Takeoff UOM[/TD]
[TD]Total[/TD]
[TD]Part Name[/TD]
[TD]Part Skew #[/TD]
[TD]Part UOM[/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD]LF[/TD]
[TD]=sum(cell A1*10%) Formulas will differ from part to part[/TD]
[TD]2x4x16 DOUGLAS FIR[/TD]
[TD]2416F[/TD]
[TD]EA[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What i am trying to do is the Part name or part skew number be searchable (to pull up the name when you type in the name or the part number in there corresponding cell and when you select that part it auto fill those cells. Below is what the MC access list would be. Only reason for the MS access database is so i can auto update parts as i get new files... Some of my Databases are up to 10k parts. Can this be done in excel stand alone or will i need script behind it.


[TABLE="width: 500"]
<tbody>[TR]
[TD]MS part # (not used)[/TD]
[TD]Part Name[/TD]
[TD]Part Skew #[/TD]
[TD]Part UOM[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2X4X16 DOUGLAS FIR[/TD]
[TD]2416F[/TD]
[TD]EA[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2X6X16 DOUGLAS FIR[/TD]
[TD]2616F[/TD]
[TD]EA[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]2X8X16 DOUGLAS FIR[/TD]
[TD]2816F[/TD]
[TD]EA[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]2X10X16 DOUGLAS FIR[/TD]
[TD]21016F[/TD]
[TD]EA[/TD]
[/TR]
</tbody>[/TABLE]

 

[alansidman]

Why not just make a query in Access to retrieve the data you want and make the calculation in the query? If necessary, you can then export the query to Excel.

 

[Ztcollins]

Cant. These will end up in a report that is sent back to our client to put into there Point of sale system. So there will be at some points over 2000 parts or better.
So basically I take off houses and provide them a parts list to build the house. These parts have to be accessible quickly so i can do these takeoff seamless and fast.