LinkBack URL
About LinkBacks
There's some examples here
http://www.excel-it.com/workbook_downloads.htm
There's some examples here
http://www.excel-it.com/workbook_downloads.htm
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
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 validationOriginally Posted by penzer
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
Investigate the stock control example & post back with specific questions.
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
relating to attachment :
as you can see i have re done a whole new basic spreadsheet as a better example.
As you can see from the attachment there is one combo box and then a stock column (this is the companies stock level). how/what do i use to then have a taking out of stock column - so lets say the stock level is 50 and them someway you then say you take out 5. THis will then be displayed as a current stock level.
I'll try to answer your questions, but you need to read up on some trhings like Dataq validation & Named ranges. There's some articles at www.excel-it.com and use Google.
1. The blue cells on the Catalogue sheet display the current selection on the Inventory shet.
2. "inv_prod" is Dynamic Named Range - look at the Insert menu>-Names>-Define to see. Dynamic Named Ranges are extremely usefulk because they expand as data is entered. There's an excellent article here
http://www.jkp-ads.com/Articles/ExcelNames.htm
3.The drop down is created by Data validation, there's an article on the site. The information is changed with VLOOKUPS,, again there is an explanation on the site.
4 & 5 The button works with VBA. Open the VB Editor to see - Alt-F11
right cheers for all your help so far: i have taken all into consideration and have created a very basic spreadsheet (quite complex for me) . im happy with it at the moment but my teacher says i need a couple more complex features.
regarding attachment.
as you can see i have one stock level, this is for pedals (the company im pretending to make for it is a bike company. the same layout/formula will be replicated for frames, forks, wheel sets etc... I was wandering if someone could adjust the data sheet in a better way. Also how do i do a macro that sets everything back to the start (0). (cant do vba as i wont remember how to do it when doing the exam)
Lastly what else can i add - stock related that involves an if statement or something vaguely complex. i need to introduce more stock managment features according to my teacher (from what i have done so far i am sure you can tell that my excel skills are not great so please suggest something that i might actually be able to do
much appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
,
Bookmarks