+ Reply to Thread
Results 1 to 3 of 3

How to select and print all options under two dropdown lists into a single PDF file

  1. #1
    Registered User
    Join Date
    07-01-2011
    Location
    canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    How to select and print all options under two dropdown lists into a single PDF file

    I have very limited coding/macro knowledge so appreciate for any help....

    Here is my question;

    I have an excel file with multiple tabs and one tab called "Discipline details" has two dropdown menus located in cell B3 and B4.

    B3 has two options (lets say A,B) and B4 has 26 options (lets say 1,2,3,4....26). I would like to write a macro to automatically select and print A-1, A-2,A-3,....A-26, B-1,B-2,....B-26 into one combined pdf file.

    I did some re-search and found some code pieces. They can do part of what I need but I could not combine them to solve the problem (print all selections from b-3, b-4 into one single pdf file.)

    1 - With below I can print an active sheet into a PDF

    Please Login or Register  to view this content.
    2 - With below I can print all options under B4 but I would like have two selections. I.e; a loop that select the main category first from B3 and print 26 sub categories from B4 and then select second main category from B3 and print 26 sub categories from B4. Also with below code I can print only to separate pdfs and at each print I need to manually define a file name.

    Please Login or Register  to view this content.
    Appreciate for any help...

    Thanks M.
    Last edited by Mkamilp; 04-24-2019 at 04:03 PM.

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,598

    Re: How to select and print all options under two dropdown lists into a single PDF file

    Please read the Forum Rules again. You should be interested in #2.

  3. #3
    Registered User
    Join Date
    07-01-2011
    Location
    canada
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: How to select and print all options under two dropdown lists into a single PDF file

    Anyone who can help?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Drop-down lists - select multiple options with sheet protection
    By jgroberts in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-27-2019, 04:33 PM
  2. Select specific options of dropdown, lock the rest
    By AsraJohanna in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-02-2018, 12:38 PM
  3. Replies: 8
    Last Post: 08-11-2016, 11:07 AM
  4. Password Protection of Single Dropdown options
    By sameise51 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-05-2015, 06:35 AM
  5. Two criteria (via dropdown lists) to get single result
    By nickwee in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2014, 06:12 AM
  6. Replies: 0
    Last Post: 03-17-2014, 02:11 PM
  7. file:Dropdown lists
    By alancauchi in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-28-2009, 04:46 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1