Hi there,
I currently have a worksheet labelled "Register".
I have this code whereby it extracts this worksheet and provides the 'save as' option to a folder.
The worksheet has headers and these headers have filters. The columns: O-U are labelled as follows:
Column O: Marston Green
Column P: Test Engineering
Column Q: West Hartford
Column R: Singapore
Column S: Xiamen
Column T: Neuss
Column U:Dubai
The data within these columns are of True/False only and the data begins on row 6.
I have created a userform interface that when ran allows the user to select a location out of the above via checkboxes and there are also three option buttons: True, False, Both.
What I'm trying to do with this userform interface is as follows:
1)
When you select a location and select True. It will filter True for that location and extract the worksheet.
When you select a location and select False it will filter False for that location extract the worksheet.
When you select a location and select BOTH true and false it will just extract the worksheet.
If one location doesn't have any True/False options and the user selects True/False and presses 'extract' - a notification will come up stating "No true/false options for this location- please amend search".
2)
The extracted worksheet doesn't have filters function on. So there are no filters on the extracted worksheet.
The current coding I have within the userform:
Bookmarks