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