Question: I have

-worksheet name "sheet2:

-Datavalidation list in G1

looking if there's a way to have macro that cycles through the data validation list and exports a workbook with the name of the text in that cell and loop through so every item of list exports as their own workbook . aka if there's 100 lines in the drop down, then i'd end with 100 excel files each individually named for the 100 drop down options.

Example , This worked for me to print out pdfs :

```
Public Sub Create_PDFs()

Dim destinationFolder As String
Dim dataValidationCell As Range, dataValidationListSource As Range, dvValueCell As Range

destinationFolder = "C:\Users\DELL 04\Desktop\Q-Book Activities\Experiment"     'Same folder as workbook containing this macro
'destinationFolder = "C:\path\to\folder\"  'Or specific folder

If Right(destinationFolder, 1) <> "\" Then destinationFolder = destinationFolder & "\"

'Cell containing data validation in-cell dropdown

Set dataValidationCell = Worksheets("sheet2").Range("G1")

'Source of data validation list

Set dataValidationListSource = Evaluate(dataValidationCell.Validation.Formula1)

'Create PDF for each data validation value

For Each dvValueCell In dataValidationListSource
    dataValidationCell.Value = dvValueCell.Value
    With dataValidationCell.Worksheet.Range("A1:I45")
        .ExportAsFixedFormat Type:=xlTypePDF, Filename:=destinationFolder & dvValueCell.Value & ".PDF", _
            Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
    End With
Next
    End Sub

```

Answer: 
The shortest version would be:

```
if option.lower() in ('admin', 'member', 'localhost'):
   ...

```
Use `.lower()` function:

```
if option.lower() =="admin" or option.lower() =="member" or option.lower() =="localhost":

```

According to the [docs](https://docs.python.org/3/library/stdtypes.html?highlight=str%20lower#str.lower):

> 
> Return a copy of the string with all the cased characters 4 converted to lowercase.
> 
> 
>