Hello,
I am wondering if it is possible to have a box that when a certain lot number is typed into it, it goes to a specific cell on a different sheet.
I am trying to work up an inventory like spreadsheet so that users can type in what they are going to be using, and it will bring them to the top of the column on another sheet that will allow them to add to that list. thank you!
Bookmarks