Macro to save array of worksheets based on values

[sdoppke]

Hi everyone, after scouring the forum, ive nothing that directly helps. Im hoping someone could help me create macro (button) to save an array that names the file based on 2 different cell values. The file path would be a file path that leads to a share drive (S:Drive)

Hope my description helps.

Thanks in advance

sd