Results 1 to 8 of 8

creating a macro to print all sheets on dropdown list

Threaded View

  1. #1
    Registered User
    Join Date
    04-04-2016
    Location
    iowa
    MS-Off Ver
    2013
    Posts
    5

    creating a macro to print all sheets on dropdown list

    I am doing this for a sports team. trying to speed up the printing process. normally if I have to print a specific sheet of workouts. lets say sheet 2, I have to go back to sheet 1 click on the dropdown list choose a new athlete then go back to sheet 2 and print. when teams get really big this takes awhile

    I am trying to create a Macro that allows me to print sheet 2 but also prints it for every athlete on the drop down list.

    can anyone guide me on how to do this if it is possible.

    I have seen similar macros on here but haven't been able to change the code to work for my data
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Macro creating new sheets from the list
    By Tapyr in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-14-2015, 08:27 AM
  2. Creating a simple macro with selection from dropdown list
    By Tescatlipoca in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-24-2014, 11:54 AM
  3. Creating/using a Macro Using two sheets of data w/dropdown
    By jnorton2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2013, 12:50 PM
  4. Creating/using a Macro Using two sheets of data w/dropdown
    By jnorton2 in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 11-02-2013, 08:28 AM
  5. [SOLVED] Macro to Unhide sheets from a Dropdown List
    By JO505 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-19-2013, 05:32 PM
  6. Creating a macro to print only the sheets and portion of sheets that i select.
    By cadamhill in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2012, 01:48 PM
  7. Need a Macro.Create new sheets from one, where need to select from a dropdown list
    By Javier091 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-23-2011, 08:47 AM

Tags for this Thread

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