![]() If anyone can help I would be most grateful. It would also be handy to know, if I am actually going about this completely the wrong way for starters. If any one needs an example of the stuff I've done so far then im sure I can furnish that. Calc, OpenOffices Excel alternative, does a good job of looking and feeling. I only really need this to work from within the building but eventually it may well need to work from outside locations too. Spreadsheets are part of the modern business world, and that means someday. I would also like to know how or even if, I can have that form on other peoples computers so if they take something from stock they can update the spreadsheet and hence keep inventory up to date. I also need to know how to point the form at the spreadsheet so the data in the form goes somewhere. as so far, I separated everything with commas, and now if I use the dropdown to test it, I just get on big list of everything and not options. Spreadsheet123s inventory spreadsheet templates for Excel, OpenOffice and Google Docs are packed with features that allow user to perform multiple tasks. This is where things get tricky, I need to know what is the correct way to add a list of choices for dropdown boxes. ![]() I have worked out how to design a form (separately from above), including labels and then next to each of those a text box or dropdown. I have also been shown how to add basic formulae so that my 'Unit cost' column and 'Stock level' column will collectively add a figure to the column for 'stock value'. I have to a degree learned how to add dropdowns to add data to particular cells, i.e for the Suppliers column, I have added a dropdown with a short list of our suppliers so that once an item is listed, then the suppliers column is easily filled from said list. I have also began to populate it, all as a test/practice. other idea - if you dont want to invest in a special program - one sheet / range with ‘inventory stock’ as start value, one sheet / range with your sales list, then you can calculate the available items with a ‘simple’ sumproduct-formula and add to either or both lists, if you add ‘negative sells’ for purchases / stock additions you. I have got as far as making a 'Calc' sheet with headings, colours etc. ![]() I do not have MS Office but instead have access to LibreOffice and OpenOffice, I am hoping that the systems are similar and that folks are happy to give help for those programs. Vertex42 focuses on Excel, so people may not know that we offer 100+ free templates for OpenOffice and LibreOffice as free. I have no prior experience of office software other than Word. So, im in the process of trying to set up a spreadsheet for inventory/stock levels at work. ![]()
0 Comments
Leave a Reply. |