I have a master list of locations in one sheet. Let’s call it ‘Location Master’. For each location, I store number of items in stock each day on a seperate sheet called ‘Inventory’.
I want my main screen to show the location name from the master and then display a number entry field which will allow the user to input directly to the ‘Inventory’ form. I want to do this without using a form button that takes the user away from the main screen, sort of like an inline list but one that works for certain form fields.
The reason I want to set it up this way is so the user doesn’t have to click buttons and leave the main screen. Is this possible and how can I do this? Thankyou in advance.