VBA Code to Save multiple files depending on multiple data valid

Hi Bylan,

With 211 different options I would organise the options (the ranges where you have the sources for the datavalidation lists) and assign range names to group my different options with different range names.

Then you could use the for each loop to run through each range name. I do not know how many different folders you need to save the different versions in, but if it is few I would do like this.

For each i in range("name of the first range")

if i.value="The cell reference of the cell with the first drop down list" and i.value="The cell reference of the cell with the second drop down list" then

activeworkbook.saveas FileName:="c:\folder1\file.xlsm"

end if
next i

For each i in range("name of the second range")

if i.value="The cell reference of the cell with the first drop down list" and i.value="The cell reference of the cell with the second drop down list" then

activeworkbook.saveas FileName:="c:\folder2\file.xlsm"

end if
next i

For each i in range("name of the third range")

if i.value="The cell reference of the cell with the first drop down list" and i.value="The cell reference of the cell with the second drop down list" then

activeworkbook.saveas FileName:="c:\folder3\file.xlsm"

end if
next i

You can also use an array to store the different options in the computer's memory, but then I will suggest that you have our Excel Advanced VBA course where we are working with arrays.

I hope this can give you some ideas to do what you want.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector