+ Reply to Thread
Results 1 to 6 of 6

Printing multiple pages of variable info using a single template.

  1. #1
    Registered User
    Join Date
    12-09-2009
    Location
    NY USA
    MS-Off Ver
    Excel 2016 and 2010
    Posts
    27

    Printing multiple pages of variable info using a single template.

    Hello experts and members!

    I'd appreciate some assistance with an issue I'm having with Excel.

    I have an issue with a client invoice system I’m trying to create on Excel 2003.

    I have created an invoice template, but the data such as Client Name, Address, Monthly Billing are all variables stored in a different worksheet in a list.

    Each row of this customer list contains information for each of many clients.

    The issue comes in when I want to figure out how I can expedite printing invoices for several clients at the push of one button.

    There is one worksheet that serves as a template, but upon print command, I would like this template to look through the client list and search for rows that are checked with a checkmark and print only those selected clients.

    If I select 10 clients out of 100, it would be great to print 10 invoices at the push of a single button using data stored in the client list worksheet.

    I’m assuming that this is a fairly difficult task. Is it even possible?

    I’d appreciate any help I can get, including which related sources I can see and study from it even.

    Thank you very much.

    Please see the attached file.
    Attached Files Attached Files
    Last edited by smk224; 07-09-2010 at 05:52 PM. Reason: Uploaded File

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,902

    Re: Printing multiple pages of variable info using a single template.

    One way is to use Checkboxes from the Forms Control, setting the reference cell for the CB to the cell underneath the CB. Then you use LOOPING code to check the range of cells in the column for TRUE or FALSE. If TRUE then that row would be used to fill the template and print...
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    12-09-2009
    Location
    NY USA
    MS-Off Ver
    Excel 2016 and 2010
    Posts
    27

    Re: Printing multiple pages of variable info using a single template.

    thank you for your prompt reply.

    I however don't have knowledge of coding so please provide me with some coding assistance if that's ok. I have attached a file in the original post in case your reply came before I made the attachment.

    Thanks =)

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,902

    Re: Printing multiple pages of variable info using a single template.

    This macro works with your example:
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    12-09-2009
    Location
    NY USA
    MS-Off Ver
    Excel 2016 and 2010
    Posts
    27

    Smile Re: Printing multiple pages of variable info using a single template.

    Quote Originally Posted by protonLeah View Post
    This macro works with your example:
    Please Login or Register  to view this content.
    Thank you so much the time you put in to help me with this! I really appreciate it.

    I will try this out and get back to this post.

  6. #6
    Registered User
    Join Date
    12-09-2009
    Location
    NY USA
    MS-Off Ver
    Excel 2016 and 2010
    Posts
    27

    Re: Printing multiple pages of variable info using a single template.

    I have worked with the macro you've provided and it was exactly what I was looking for. Thank you.

    I however have one more function I'd like to add to the client list page but don't know how to make the macro.

    I have added 4 radio buttons, Select All, Select None, Select Good Clients, Select Bad Clients.

    Depending on the group set for each row on E3 to E5, how can I make this happen?

    The excel file is attached with the radio buttons (albeit no macros)

    Thanks ^.^
    Attached Files Attached Files

+ 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