Hi,
I am new to macros and VBA and need some help. I am also new to this forum and I am looking for any help or ideas that you might have.
I have a workbook with 50+ worksheets. I have to find each worksheets that contains the same location and save it to a folder that uses the name of Manager. Each Worksheet contains the name of the geographical location and the name of the building on Cell M1. On Cell N1 I have the name of the Manager's name. On my C:\ Drive I have a folder with the name of each manager. So, for example, my first three tabs have the location of CM126 RD1111 (on cell M3) and the Manager's name is John Smith (on cell N1). I need to print these three worksheet to one PDF file and save them to my folder Name C:\John Smith and so forth. Any help will be greatly appreciated!
I am new to macros and VBA and need some help. I am also new to this forum and I am looking for any help or ideas that you might have.
I have a workbook with 50+ worksheets. I have to find each worksheets that contains the same location and save it to a folder that uses the name of Manager. Each Worksheet contains the name of the geographical location and the name of the building on Cell M1. On Cell N1 I have the name of the Manager's name. On my C:\ Drive I have a folder with the name of each manager. So, for example, my first three tabs have the location of CM126 RD1111 (on cell M3) and the Manager's name is John Smith (on cell N1). I need to print these three worksheet to one PDF file and save them to my folder Name C:\John Smith and so forth. Any help will be greatly appreciated!