Easy way to add items to a list on a different sheet

[zaibuojantis]

Hello I have my companies inventory document with aproximately 1000+ items in it, we track and record items that are being used or when they are idle. On the inventory list one sheet1 is used to show information about current items, sheet2 holds all item names and inventory numbers. For selecting which item goes to sheet1 we use drop down list on that sheet and select items from sheet2. But from time to time we get to deal with new items that aren't even in our current inventory and for that I need to open up sheet2 find a place between 1000+ items and enter to a cell so the item would appear in the drop down list on sheet1. My question is what is the solution here to minimize time spent to add new items to our list, what I think ideal would be to have a cell that when you add a value to it and press enter it automaticaly sends that value to sheet2 and adds to the last place on my inventory. I made a screenshot example of what I think is best. Thank you!For Excel forum.png

[AlphaFrog]

This will add the item to the bottom of the list. Uncomment the Green sort code if you want the list sorted each time a new item is added.

If you haven't already done so, make your dropdown list dynamic.
Create a Dynamic Named Range

To install the code:

• Right-click on the Sheet1 tab.
• Select View Code from the pop-up context menu.
• Paste the code from below in the worksheet's code module.

Please Login or Register  to view this content.

[zaibuojantis]

Thank you! Your code helped me a lot!