Formula for 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!

[AliGW]

You will need some code (VBA) for this, so I have moved your thread.