Creating A Database And Using The Data For Project Quotes

[shearstrength]

Using Excel 2000;

I would like to create a "Master" database of components (example; bolts, nuts, washers, description, unit price, etc.) and use this data in new worksheets to provide clients a complete project quote, without having to constantly retype the information over and over.

What would be the best approach?

Any response will be greatly appreciated!

 

[pipewelder1999]

Here is the link to the example I spoke of. It took around 15 min to throw togetherso don't expect anything fancy. It does address the original question posted.

http://www.weldinginspectionsvcs.com/lookupparts.htm

Gerald Austin
Iuka, Mississippi

http://www.weldinginspectionsvcs.com