Stock levels

**davesexcel** · 03-29-2008, 07:18 AM

Originally Posted by penzer

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.

Let's see your example......

**royUK** · 03-29-2008, 10:04 AM

let's see what you have so far, I think you want us to o a homework project for you!!!!!

**penzer** · 03-29-2008, 12:56 PM

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

**royUK** · 03-29-2008, 01:14 PM

There's some examples here

http://www.excel-it.com/workbook_downloads.htm

**penzer** · 03-30-2008, 12:20 PM

cheers for that link, very useful however it is a bit too complicated for me i cant understand it even after reading the information so therfore i wont be able to do it myself.

**davesexcel** · 03-30-2008, 01:12 PM

Originally Posted by penzer

cheers for that link, very useful however it is a bit too complicated for me i cant understand it even after reading the information so therfore i wont be able to do it myself.

Here's how to get the drop down menu in a cell using data validation
http://www.contextures.com/xlDataVal01.html

Check out other info on that site for help,

For inventory control, you may be stuck with using some VBA for this,
of course access would be the proper program to use for inventory control

**royUK** · 03-30-2008, 01:43 PM

Originally Posted by penzer

cheers for that link, very useful however it is a bit too complicated for me i cant understand it even after reading the information so therfore i wont be able to do it myself.

Investigate the stock control example & post back with specific questions.

**penzer** · 03-30-2008, 04:22 PM

ok i dont get:

1) on the catalogue sheet there is two of the same sections , the lower one has widgets and wodgets and the top one has just got wodgets am i correct in thinking its just to show the formula.?

2) =(SUMIF(inv_prod,B10,inv_recd)-SUMIF(inv_prod,B10,inv_used))-E10+F10
when looking at the formula i dont understand the "inv_prod" etc i know where it is from looking at the forumula break down but why is it called this because i cant see a column name?

3) on the inventory page how do they get the inormation to change when the drop down list changes,

4) how does the "update button work"

5) when you press the button how do they get it to so another row appears.

yehhhh many questions. thanks

Stock levels

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions