punty
04-17-2018, 10:08 PM
I have a dropdown in one of my sheets, selecting any one item in the dropdown updates 4 sheets and then the data in 4 sheets are converted into PDF.
I am facing problem in automating this step. I am able to generate PDF through Macro but in the drop-down list. I am not able to automate selection of entries.
Sub Test6()
'
' Test6 Macro
'
' Keyboard Shortcut: Ctrl+k
'
Range("B4:C4").Select
Application.Run "'Copy of North TSC Format (2).xlsm'!PDFActiveSheet"
Sheets("Talent Scorecard - CV Passenger").Select
Application.Run "'Copy of North TSC Format (2).xlsm'!PDFActiveSheet"
Sheets("Talent Scorecard - SCV Cargo").Select
Application.Run "'Copy of North TSC Format (2).xlsm'!PDFActiveSheet"
Sheets("Talent Scorecard - MHCV").Select
Application.Run "'Copy of North TSC Format (2).xlsm'!PDFActiveSheet"
I want this to repeat for other entries in the drop-down list.
Can anyone help me in this?
I am facing problem in automating this step. I am able to generate PDF through Macro but in the drop-down list. I am not able to automate selection of entries.
Sub Test6()
'
' Test6 Macro
'
' Keyboard Shortcut: Ctrl+k
'
Range("B4:C4").Select
Application.Run "'Copy of North TSC Format (2).xlsm'!PDFActiveSheet"
Sheets("Talent Scorecard - CV Passenger").Select
Application.Run "'Copy of North TSC Format (2).xlsm'!PDFActiveSheet"
Sheets("Talent Scorecard - SCV Cargo").Select
Application.Run "'Copy of North TSC Format (2).xlsm'!PDFActiveSheet"
Sheets("Talent Scorecard - MHCV").Select
Application.Run "'Copy of North TSC Format (2).xlsm'!PDFActiveSheet"
I want this to repeat for other entries in the drop-down list.
Can anyone help me in this?