#1   Report Post  
Posted to microsoft.public.excel.misc
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!!!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sales journal and inventory management benwmen Excel Discussion (Misc queries) 4 April 27th 06 03:24 PM
Inventory Age jvanzomeren Excel Worksheet Functions 1 February 17th 06 06:21 PM
Associating data across worksheets from an inventory that's sorted Ian Excel Discussion (Misc queries) 0 November 18th 05 04:26 PM
Inventory List Question snoopy Excel Discussion (Misc queries) 0 November 10th 05 07:58 PM
Inventory sheet to track, order & reduce quantity from master. drc536 New Users to Excel 2 October 23rd 05 05:36 PM


All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"