Save As to a Pass or Fail folder based on cell result

[amartin575]

Hello,

I have the below code which saves files down by looping through a dropdown list in a data validation cell. It actually goes to the hidden tab and loops through the range that the data validation cell is linked to. What I need it to do is save to one location if cell A1 equals pass (a folder labeled pass) and save to a failed folder if A1 equals Fail. The current code is below. The code is also not setting the drop down selection to the ID in the list. It is remaining on the first item but the save as is saving correctly.

Please Login or Register  to view this content.

[amartin575]

I have the part where it sets the data validation item to the next one. I just need the save to one specific pass folder if a cell says pass and a fail folder if the same cell says fail.

Please Login or Register  to view this content.

[amartin575]

Hello,

I was able to figure it out. Thanks to everyone that was looking!

Please Login or Register  to view this content.