example.xlsx
I have a workbook with the first page containing strings of 2 and 3 character letter groups. Attached is the example of the data page. What i need is the ability to sort through all the cells and generate a list of cell addresses based on pre-determined search criteria. Such as searching for the letters "VC". Some of the lists i need may be dependant on finding a cell meeting several criteria such as "OGR" AND "CI".
The resultant list of cell addresses would be most useful in a named range so i can put them in a dropdown menu on different worksheets. I just can't figure out how to create a named range that will return what i need across the entire range of cells.
This worksheet cannot grow larger then A1:Z25, but all cells within that range are fair game and i will be changing them over time to track what i need.
Any ideas, pointers?
Any help would be greatly appreciated as i am REALLY lost.
Bookmarks