If JRY selected from Picklist then a input box will appear. Entry stored on seperate sheet
I have a pick list of various codes, when user selects only JRY I would like an input box to come up requesting user input "Jury ID", the value would be stored on a seperate sheet along with a Date and Employee Needing Coverage name from the same line were JRY appears. This is a form so JRY could appear 2 - 3 times in a month on any line in the range of C15 - C84. . There are various other codes in the picklist but only "JRY" will trigger the input box, then when inputed box would go away. User would remain on "Form" sheet. Expert-Echange-image.jpg
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.