Thread: Macro Buttons for Editing and Adding Inventory

I am including the current file that I have attached to this post.

I am very new to using macros and I am trying to keep an inventory of instruments and I need some help. I found this macro and have edited to my liking as far as editing the inventory pages, however I need help developing it further and adding another macro button in order to add lines of inventory. I will try my best to explain what exactly I am looking for.

On the current "Edit Inventory" button, it can edit inventory according to model # and will make the necessary changes in the worksheet "Inventory." However, I also have a HistoryList worksheet and I need it to input the following things to the historylist. I would like the button to do the following: I am able to insert up to 5 different items at a time. I would like to be able to have a new combobox section for the different brand names. I would like to be able to select the brand names, and then the combobox for the models would only show the select models associated with the brand name listed. I would then like to be able to insert the one of the reasons for the inventory change in the drop down menu from the "info" worksheet. I would then like each of these things to transfer over to the history list upon hitting the submit button and each of the selections besides the user and time to clear in order to be able to input once again.

I would then like to create a second button in order to add inventory. I would like the second button to be based off of the first button in that, if the selected brand and model number that is selected for editing the inventory is not currently on the list, then it pops up a second box asking for the things I have on the inventory worksheet, being the instrument, the model, the brand, a description, and the new quantity to input...and then it pastes it to the bottom of the instrument page.

I know this is a lot to ask for and that it may take some time, but I am at an absolute stand still with being able to develop more macro and need some help. I would love to work with someone to help me develop this inventory system.

Thanks,

PHIL

Well im not very competent at writing code as I only found this macro online and have edited it to my liking. I will check out the link posted, but if anyone knows how to write the code for what im looking for that would be great help.

Phil

Yes, I have not made the macro button for the part that you quoted because I do not know how to read the code. The information would be provided from the inventory sheet that is already present.

Ok, here is what I am trying to work with.

Sorry, I have been really busy with other stuff this week so far. The model numbers ARE UNIQUE to the brand/manufacturer, and they are also specific to the instrument type. Every instrument should ALWAYS have a model number. I believe some on the list I gave you don't have some model numbers, but that is only because I haven't been able to figure them out yet.

Thank you very much.