Need help with code to save file in a folder location based on a cell value

Hello,

Here is what my code currently does - It loops through the values in column 4, filters the data, pastes the data to a new sheet, creates a PDF and saves the file in the file path that I specify in cell A12. Currently, all files created are saved within the same folder.

What I need the code to do - I need the code to catch the value of the first column (manager) and save the data within that specific folder. For example, all the data for "Employee A" will be saved in the folder called "John". I do not need the macro to create the individual folders, I can do that manually. What is the best way to do this? I believe I need to somehow tell the Filename argument to pick this up but I keep getting errors.

Please Login or Register  to view this content.