Loop Data validation list item and generate PDF for each

Hi Team,

I have gone through various sites, but, not found what I am looking for. If the post is not valid, my apologize for this.

Here is what the post is about:
1. I have created a Named range using Macro. The named range used in data validation list, placed in cell H9 with in "Invoice Format" sheet.
2. If I select the item in the list manually, it is fine, values will change accordingly in the format - used look-ups.
3. Here comes what I required is - The list should automatically loop within and the format should capture as "PDF" file for each value in the List item.

In the file attached here is, in the "Invoice Format" sheet, there is two page format. Where in the second page of the format/template the values in it will show based on the column G in the "DSR_Format" sheet. If the values in second page of the Invoice Format sheet is visible, then only the second page also should capture in the PDF. Other wise, one page as PDF.

Hope I am clear with the above. If not, let me know.

Poste on http://www.ozgrid.com/forum/showthre...113#post682113
http://www.vbaexpress.com/forum/show...311#post296311

Thanks
Chaitanya

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

Hi Arlu,

Got it, thanks for the suggestion.

My problem got solved by another forums member in VBAX. There with the same title anyone can find for solution.