Tech Support Forum banner
Status
Not open for further replies.
1 - 6 of 6 Posts

·
Registered
Joined
·
2 Posts
Discussion Starter · #1 ·
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.

ttt
Jay
 

Attachments

·
Grammar Nazi!
Joined
·
3,865 Posts
It's not a .rar file, he just renamed it from *.xls to *.rar to be able to upload it.
 

·
TSF - Emeritus
Joined
·
1,225 Posts
Hey J,

Just compress the .xls file into a zip or rar file. Zip is more common on this site. If you don't have a program that compresses files, check out 7zip. It is free.

Regards,

Robert D. Specian Jr.
 

·
Grammar Nazi!
Joined
·
3,865 Posts
Hey Robert,

His file is fine if you just download it and rename it with a .xls. Mine is a legit .zip file.

I almost have a solution coded, can you take a look 'cause I always struggle with Excel VBA, module 4 is the Submit button code. My functional design comments are in the case statement.

Jay:

I don't think what you are trying to do is difficult at all. Personally I'd have done it in MS Access, but we won't go there right now...:grin:
 

Attachments

·
Registered
Joined
·
2 Posts
Discussion Starter · #6 ·
thanks for the help... I built the sheet just coping and pasting the code that i needed to get it to that point, but spent some time today diving into what it means and how it works.

I just started with this type of excel depth about a week ago so its ALL still a mystery to me.

Thanks again.
 
1 - 6 of 6 Posts
Status
Not open for further replies.
Top