Spare Parts Management Using Macros & VBA

Hi All,

I have been dabbling with a bit a macros and VB to manage some maintenance related tasks at my place of work. I have a low to mid level understanding of Excel and would really appreciate any of your assistance with this workbook I am working on...

The workbook contains multiple sheets with each sheet relating to spares for a particular machine and the location of these spares.
Smithfield Spare Parts Stock.xlsm

I would like to create a main sheet (which I have started on), to enable an easy find and display function by the click of a command button (please see attached sheet). I have also created a combobox with selections for each sheet in the book. I am keen to achieve the following outcome:

1) Required machine selected from Combobox
2) OEM part number or Local part number or part description filled in (any one of them only)
3) On clicking the Search part location (command button) the fields for the new stock, repaired stock, rack no., shelf no., and bin no. to be populated automatically.
4) If part can't be located - then message part not available
5) When part has been located, and staff need to book out the spare, the required quantity to be entered in the book out section and entered with the command button. This should then subtract the quantity from the appropriate column (new / repaired)
6) Conversely, when new parts or repaired parts come back, they are to be received with the receive button. This should then add that part into the appropriate column (new / repaired)

I hope I have not confused you with my requests but any help on this will be much appreciated...

Many thanks ....

Hi NoviceExcelMan,

I was really impressed with your work. Did you got it working finally?. Can you please send me a copy. I really appreciate your time and help.

Thanks,
Hernando

hi guys, I'm looking for pretty much the same outcomes you are. Is there a way to get a copy of the working program?

Francisco