I have a [very] hidden list which is usedin a Vlookup, if the Vlookup cannot find what it is looking up it returns 'Not inRegion List'
I would like to add a button to the worksheet that allows the user to add the details to the bottom of the list without the need of unhiding the sheet.
The list is in a worksheet called Static and has two columns. Column A is Market column B is Region. The list has been named as Regions.
Can an expert assist with this one please.