ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   INVENTORY (https://www.excelbanter.com/excel-discussion-misc-queries/104920-re-inventory.html)

Jim May

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!!!



All times are GMT +1. The time now is 12:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com