Hello!
I was wondering if someone can help me with this task. I'm not very good at Macros. I have a file with about 150 sheets. I want to be able to save every sheet to pdf format and rename it from a list located in the worksheet. Name of file would look like this JJones-1stGP-Speech-23-24.pdf Every sheet matches the list. It would be even better if I there is some sort of button that can be pressed and it can initiate the process. I would really appreciate your help with this task.
I was wondering if someone can help me with this task. I'm not very good at Macros. I have a file with about 150 sheets. I want to be able to save every sheet to pdf format and rename it from a list located in the worksheet. Name of file would look like this JJones-1stGP-Speech-23-24.pdf Every sheet matches the list. It would be even better if I there is some sort of button that can be pressed and it can initiate the process. I would really appreciate your help with this task.