I've very new to VBA, I have a excel spreadsheet that produces report from a number of various other sheets within the same document.
What I want to do is create a macro that once it runs, produces one PDF of each report and saves into one PDF in the order that from the drop-down list, show the page number in the bottom in the same order as the dropdown list and show the date as well. also the PDF will be saved with a given name
I am not sure if this is possible to do, but i am trying to save each report from the drop down list into a new temp workbook, and then print them all from that temp workbook then delete that temp workbook.
but the code i get so far, (it works) it saves each report into a different new workbook and does not print to PDF.
but if you have better solution, please share with me !!!
Dim dvCell As Range
Dim inputRange As Range
Dim wb As Workbook
Dim c As Range
Dim i As Long
Dim rngLoopRange As Range
Dim wsSummary As Worksheet
Dim rngDealers As Worksheet
'Which cell has data validation
Set dvCell = Worksheets("Projections").Range("R2")
'Determine where validation comes from
Set inputRange = Evaluate(dvCell.Validation.Formula1)
i = 1
'Begin our loop
Application.ScreenUpdating = False
For Each c In inputRange
dvCell = c.Value
Set wb = Workbooks.Add
i = i + 1
Application.ScreenUpdating = True