Hi Excel world,
Been looking for a solution for this for hours and my eyes hurt.
I have a worksheet that is an individual program that is set up with Vlookup's etc that feed into this worksheet. On the worksheet (labelled "Program") there is a drop down menu with the name of the person in cell "E2".
I have successfully used a macro to allow me to save a PDF for one person at a time (by manually selecting a person from the drop down menu and then running the macro). However I can have up to 100 people in that drop-down list and I want a Macro that will save all to individual PDF's without having to select each one.
I am very new to Macro use so I am a little hopeless with understanding it all.
If anyone could help, that would be great!!
Thanks in advance!
Been looking for a solution for this for hours and my eyes hurt.
I have a worksheet that is an individual program that is set up with Vlookup's etc that feed into this worksheet. On the worksheet (labelled "Program") there is a drop down menu with the name of the person in cell "E2".
I have successfully used a macro to allow me to save a PDF for one person at a time (by manually selecting a person from the drop down menu and then running the macro). However I can have up to 100 people in that drop-down list and I want a Macro that will save all to individual PDF's without having to select each one.
I am very new to Macro use so I am a little hopeless with understanding it all.
If anyone could help, that would be great!!
Thanks in advance!
