View Single Post
 
Old 04-08-2023, 05:46 PM
sbaidoo10 sbaidoo10 is offline Windows 10 Office 2019
Novice
 
Join Date: Apr 2023
Posts: 2
sbaidoo10 is on a distinguished road
Default How to create a subroutine that allows the user to select the Identifier & ID from a drop-down menu

If range A2:C26 contains data, and column A (Batch ID) has hyphenated data with a two-digit code to the left of the hyphen and a 4-digit code to the right of the hyphen in column A.
The first letter of the Batch ID is known as the Identifier and the leading number of the 4-digit code to the right of the hyphen is known as the Key.
For example, in the Batch ID "N9-363B", the Identifier is "N" and the Key is 3:

How do I create a subroutine that allows me to select the Identifier from a drop-down menu in cell F2 and the Key from a drop-down menu in cell F3 and any rows of the data (columns A, B, and C) whose Batch ID meets those criteria to be highlighted GREEN.
Reply With Quote