I'm working on an excel form at the moment, and one of the things I want to be able to do with it is save it to a specific location
However, the location varies depending on which person the form relates to
I have a group of folders that has everyone's name allocated to one folder, and i need to save the document to somewhere in those folders
Is there some sort of way to search a group of folders for part of a folder name and use that as an identifier?
If you need more clarification please let me know. I'm sure there's a way to do this but i dont know how