FIRST POST: I have no idea what makes VBA codes work but can usually take someone elses code provided they have notes to help me and change the cell references and worksheet names so that they will work for me. ie I am completly dependent on others knowledge. I am looking for a vba code that will loop through a data validation dropdown and take the resulting sheet and save it in a new workbook and break the links to the original data/file and use the dropdown as the file name. I have a vba code that will save as a pdf - but I need it to be an excel file. Can anyone help get me started?