Database for Purchased goods
- From: "Troy" <Troy@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 14 Jul 2005 11:48:01 -0700
Hi
I would like to setup a database for our company that would hold all of our
purchased in parts.
I want to have 3 main headings. "Raw Material Numbers" - "Description" -
"Category"
I want to be able to search by either Raw Material Number or Category. Lets
say I have a RAw material number I want to search. I will input that number
under "Raw Material Numbers" and excel will search the database and find the
number and return the Description and Category. That part I think I have
down, it's the next part that gets me.
I also want to search by category. Lets say I have 5 categories, "Nuts",
"Bolts","Washers","Cotter Pins", and "Gaskets". I might want to search for a
Washer's "Raw material number". So I select to search by the Category
"Washers", and excel will return all numbers, descriptions in that category.
I am sure this is possible, just have no clue how to do it. Is there already
a template that would work, or that I could modify??
TIA
XP Small Business
.
- Follow-Ups:
- Re: Database for Purchased goods
- From: Earl Kiosterud
- Re: Database for Purchased goods
- Prev by Date: Re: Question about auto fills or linking sheets
- Next by Date: Re: Ranking Alphabetically
- Previous by thread: how to sort A to Z AND 0 to 9?
- Next by thread: Re: Database for Purchased goods
- Index(es):