Good time of the day.
I am currently creating stock control program.
My question is, how would I create a stock control macro in this kind of situation:
8412ae9da491.png
Where I have a list of chosen equipment and the quantity of that equipment to be subtracted from the list of equipment here
4b64c55999d9.png
Best regards, Vlad
If you want help with Excel then post an example workboo, not images
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Here it is
The names don't match in each sheet. To start with you need to use Data Validation lists to select the items from
modified, should be ok now
Is it all right?
Try this assigned to your button
Please Login or Register to view this content.
Could you please explain this line
I have some troubles with moving this code into actual project.If Not rStock Is Nothing Then rStock.Offset(, 1).Value = rStock.Offset(, _
1).Value - rCl.Offset(, 1).Value
End With
Also, where would I put piece of code which will not allow stock to go below zero?
Thanks so far.
It's allowing for the cell not being found
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks