Results 1 to 3 of 3

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

Threaded View

  1. #1
    Registered User
    Join Date
    06-26-2018
    Location
    Lithuania
    MS-Off Ver
    2016
    Posts
    60

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

    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
    Last edited by zaibuojantis; 01-11-2019 at 10:35 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula for easy way to add items to a list on a different sheet
    By zaibuojantis in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-08-2019, 06:52 AM
  2. Formula for easy way to add items to a list on a different sheet
    By zaibuojantis in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-08-2019, 06:47 AM
  3. [SOLVED] Sort List of items from one sheet to another.
    By colddeck84 in forum Excel Programming / VBA / Macros
    Replies: 47
    Last Post: 12-16-2017, 01:03 PM
  4. [SOLVED] Average group of items on one sheet from list of data value on another sheet
    By janljan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-04-2017, 09:46 PM
  5. Autopopulate items from one sheet to another based off list selection.
    By creed84 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-04-2015, 02:17 AM
  6. [SOLVED] Easy selecting of items in List
    By pansovic in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-17-2014, 10:43 PM
  7. VBA code: automplete a column from a list of items in a different sheet
    By kakkerlat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2013, 02:32 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1