T-shirt inventory system


Hello, can anyone help me, im looking to create a inventory system. I have a few brand t-shirts and i want to have where i select one brand  it would link to the size and price and quantity and color,

for example: i  would choose a brand name Gildan and the price, size, color and quantity would show for each size would have a different price and for the color it would let me know how many i have in each size. 

if any one can help would greatly appreciate it. 




Are you starting it from scratch? How will you update the system - by hand or using some other software?

I can could give you a small template to get you started but, to be honest, Excel is not the most reliable inventory system if you are dealing with large, or simply important, quantities.
don (rep: 1521) Mar 10, '17 at 7:30 am
it would be by hand 
phoneguy (rep: 8) Mar 10, '17 at 7:45 am
if you can send me the small template i would greatly appreciate it 
phoneguy (rep: 8) Mar 10, '17 at 8:10 am
Add to Discussion


Selected Answer

Attached is a simple way to do it.

Use Filters or PivotTables to sort through the data.

I would start wil Filters to get what you want first.



thanks, i appreciate it but that i can do myself  im looking do something a little more complex than that automated inventory system 
phoneguy (rep: 8) Mar 13, '17 at 10:49 am
Thats how you would store the data. Are you saying that you want a different way to retrieve the results instead of using something like a filter? As in, you are trying to build another worksheet that shows only the result for the given criteria? You gotta be more specific. Your other question also is not specific enough to help. There needs to be a sample file and, from that it will be easier to help you create the formulas or other methods to get the results. So, if you are using your own template, just upload that to the other question you asked, along with an example of the output you want, and I should get a notice that you made an update and can take a look at it.
don (rep: 1521) Mar 13, '17 at 12:32 pm
Just saw your new question, I will take a look at it in the morning.
don (rep: 1521) Mar 13, '17 at 12:34 pm
i thought i did uploaded my what i had, i had posted another question it have my template there its multiple lookups 
phoneguy (rep: 8) Mar 13, '17 at 2:45 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login