Stock levels

Hi there, for my new ict project i intend on managing stock levels.

My idea will be based on a bike shop, so the stock will be of frames,pedals,forks etc etc.

What i want to know is how to go about actually doing it,

For an old project which was a till system i had two sheets,a data sheet and till system sheet , the data sheet contained :

example:
column A - numbering of the data (to be used with V Lookup)
column B - product name
Column C - price
This would then be replicated in the next 3 cells for the next data category.

Till system then had a combo box which had a cell link on the current page and data from the data sheet and then i had a price column next to i (containing V Lookup formula) the price then changed depending on the choice in the combo box.

I want to incorporate combo box's in to this new project. If i can then get some kind of stock thing i intend on then using conditional formating to colour code stock levels to show severity of needing to order etc.. sorry for the waffle.

any help would be appreciated .. if you can help please write in noob step by step

thats really good, by the way my combo box's are not in cells kind of thing, how do you make them part of the cell like the ones you attached. However i don't think i made my question/request very clear as i have i have got this type thing already, i am trying to find out how i make it more like a stock/inventory management type thing. So like no need for price but more like the products would be in a combo box and it would then show how much stock there was and then there would be a way to actually input what your stock levels are and then by clicking on the desired product from the list it would show you how much stock there was, I hope this makes some kind of sense..


but cheers for that spreadsheet attached, helped me out quite a bit.

i hope i just attached it,, this is not relevant to the stock project but as you can see from the attached file i can do the v-lookup - i was intending on changing the price data to the stock level. so then i would select from the combo box and it will show me the stock level. However i cant seem to find a way without using vba how to then manage the stock by entering how much of one stock i have taken out (if that makes sense). I intend on then colour coding the stock levels to show severity of stock levels (conditional formatting i think does this colour).
ps. how do i make my combo box's part of the cell , in my attacthed file they float above cells, ive seen people have drop down/combo boxes part of the cell.

thanks