LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Simple Inventory

Okay, I have looked at the Inventory Templates for Access and also for Excel
and haven't found anything that quite meets my needs -- and not smart enough
to mess with what templates are there to make them work the way I want.

So this is what I am looking to do and maybe someone can point me towards a
template or tell me how I might edit an existing Microsoft template.

1. Dealing with apparel inventory
2. Want to be able to pick an item from a list (e.g. T-shirt, Fleece)
3. Based upon what is selected in #2 the next column would be Brand (Hanes,
Gildan, etc.)
4. Based upon what is selected in #3 the next column would be Style (5370,
2000, etc.)
5. Based upon what is finally selected in #4 I would be presented with the
information related to that specific Style -- which would be
a. each of the colors in that style
b. the sizes in each color
c. and the quantity on hand in each size/color
6. Then be able to change the quantity

I don't need to worry about PO# or anything else -- just look up and see
what I have in stock for a particular Product/Brand/Style by size & color and
modify it.

Any assistance or guidance would be more than appreciated. Thanks
 
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
IF formula-simple question; simple operator Rich D Excel Discussion (Misc queries) 4 December 6th 07 03:36 PM
Simple problem, simple formula, no FUNCTION ! Ron@Buy Excel Worksheet Functions 6 September 28th 07 04:51 PM
simple inventory totals johhny g Excel Worksheet Functions 1 April 3rd 07 05:19 AM
how to build simple inventory system sureshbabussb Excel Discussion (Misc queries) 0 December 6th 05 03:36 AM
How can i get an inventory list that adds and subtracts inventory James Excel Discussion (Misc queries) 0 October 5th 05 12:48 AM


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

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

About Us

"It's about Microsoft Excel"