Well i'm a noob that got handed this project today at work.
I have created what i think is a working inventory sheet, with the In-Out workbook setup and sorted like my Acct dept needs it. But it is lacking the running totals at the end.
I need LOTS help with the last part though. It might be too tall an order but i'll ask anyway.
What do i need to do to have the sheet update the "current stock" cells based on what is filled out and "submitted" with my button?
Say if "Received", "5", and "HP 2035" is selected in the drop down then i click "submit", i need the "Current Stock" number next to "HP2035" to be changed by +5 and the "On Order" field next to "HP2035" to change by -5.
I think i can change the code to have the "Current Stock" go -1 if the drop down "Received" is changed to "Installed" under the same criteria, but that might be putting too much faith in myself at this point.
Take a look. Its attached. Renamed a .rar from a .xls. It wouldn't let me upload a .xls. Its Excel 2003 btw
Thanks for even looking and shaking your head at my noob pipe dream.
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!