Thread: INVENTORY
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jim May Jim May is offline
external usenet poster
 
Posts: 477
Default INVENTORY

Set up a table - Row 1 will be your Header (Titles which describe the content
of rows 2 thru 1,000...
Type in:
A1 = Stock#
B1 = Year
C1 = Make

Come back and in Row 2 enter the info relative to your first vehicle;
Row 3 for the 2nd vehicle,,, and so on..

After all records are in set up an Auto-Filter




"TOP" wrote:

I want to develop a vehicle inventory which includes age in stock, stock #,
year, make, model, VIN, price and cost. At a glance I would like to know
what total cost is and be able to find a vehicle by stock # or VIN. H E L
P!!!