kbmanwatkar
06-21-2019, 06:37 AM
Hi..
Require Help in doing this automation..through VBA Code. If any one can help, will be highly appreciated.. I have one file with main database and other three output sheets e.g. slide 1, slide 2 and slide 3. (This is sample database).
At his moment, sheets slide 1, 2 and 3 is displaying data output for Department=Sales A.. Accordingly, when one selects, Department=Sales B, these three output sheets will show data for Sales B and so on.
Sales A, B, C etc are department names...
Now I require to generate powperpoint file with these output sheets i.e. Slide 1, 2 and 3. The Powerpoint file (with slides Slide1, Slide2, Slide3 on below other) thus generated also required to be saved as Sales A.ppt, Sales B.ppt etc..for respective output generated. I have already posted above both the files..(input and output required)..(uploading both excel and output file in powerpoint).
Thanks and Regards,
KBM
Require Help in doing this automation..through VBA Code. If any one can help, will be highly appreciated.. I have one file with main database and other three output sheets e.g. slide 1, slide 2 and slide 3. (This is sample database).
At his moment, sheets slide 1, 2 and 3 is displaying data output for Department=Sales A.. Accordingly, when one selects, Department=Sales B, these three output sheets will show data for Sales B and so on.
Sales A, B, C etc are department names...
Now I require to generate powperpoint file with these output sheets i.e. Slide 1, 2 and 3. The Powerpoint file (with slides Slide1, Slide2, Slide3 on below other) thus generated also required to be saved as Sales A.ppt, Sales B.ppt etc..for respective output generated. I have already posted above both the files..(input and output required)..(uploading both excel and output file in powerpoint).
Thanks and Regards,
KBM