+ Reply to Thread
Results 1 to 3 of 3

Print in specific order

  1. #1
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Print in specific order

    Hello Everyone,

    As the title says, I have a very specific printing macro that I would like to try out. Here is exactly what I would like:

    In a workbook, on Sheet1 I want to make a button that runs a macro that will print:

    Sheet5
    Sheet7
    Sheet8
    Sheet9
    Sheet10
    Email 1
    Email 2

    I'm guessing the sheets aren't very hard to write a macro to print out, but is it possible to build the emails in? The emails would be in Outlook but I would like to have them in the workbook so can I either save the email and paste the file name (and then have the macro reference the cell the filename is in) or is it possible to paste the email into excel without losing the formatting and everything?

    Also, I will always need to print all of them at least once, but sometimes I will need to print some of them multiple times. So I would like to choose how many of each I print. Is it possible to build something into the macro that chooses how many times you print each part out?

    Since the amount of each sheet I need to print on would depend on what is chosen from a dropdown in Sheet1CellA2, is it possible to make some type of "array" macro that bases what it prints off of a dropdown?

    I know this is very detailed and is probably a pain if its possible but I would really appreciate the help!

    Thank you in advance!

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Print in specific order

    Hello freybe06,

    You are really asking two questions here. One about printing the sheets and the other about emails. I am going to focus on only printing the sheets as the email question is radically different.

    The sheets can be printed in any order and you can be prompted for the number of copies. This statement does not make any sense to me. Can you explain this further, or post a sample workbook?
    Since the amount of each sheet I need to print on would depend on what is chosen from a dropdown in Sheet1CellA2, is it possible to make some type of "array" macro that bases what it prints off of a dropdown?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    06-17-2010
    Location
    Philadelphia, PA
    MS-Off Ver
    Excel 2010
    Posts
    228

    Re: Print in specific order

    Sorry for the confusion Leith - what I'm trying to ask is would it be possible for the macro to print based on what is in cell Sheet1CellA2? For example:

    If Sheet1CellA2 says "January" the macro would print Sheet5, Sheet7, 3 copies of Sheet8, 2 copies of Sheet9, Sheet10, Email 1, and Email 2.

    If Sheet1CellA2 says "February" the macro would print 2 copies of Sheet5, Sheet7, 2 copies of Sheet8, Sheet9, 2 copies of sheet Sheet10, Email 1, and and 2 copies of Email 2.


    Thanks for your help!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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