Hey so i will try my best to describe my intentions here
I have an invoice setup with 4 buttons on the side, one to save as a excel file, second to save as a pdf file and the 3rd button sends a pdf as an email through outlook. the 4th button just clears specific cells in the invoice.
When i save the the file it copies values in specific cells and saves it in a specific folder
"Invoice"(B3), "900"(F5), "Business Name"(B13(merged)C13)
Looks like this:
"Invoice 900 Business Name"
So, is it possible to tweak this to have the same save options but the "business name "will automatically save to the related business name sub folder if changed in excel.
i hope that makes sense