+ Reply to Thread
Results 1 to 8 of 8

Combination of fixed and dynamic print ranges

  1. #1
    Registered User
    Join Date
    12-29-2014
    Location
    Edmonton
    MS-Off Ver
    Office 2010
    Posts
    12

    Combination of fixed and dynamic print ranges

    Here is my dilemma.

    1.
    I have a document where the first page is a static set of rows and columns. Basically updated once and then with the exception of changing percentages remains the same where as all the same rows and columns need to print. That seems pretty straight forward. Set a print area of that range. This is the "original contract" section.

    2.
    I have on the second (or more) page(s) of this document a range of cells that from month to month can change. Mostly just get larger as months progress. This is called "Change Orders" section. This section has a dynamic list of entries that total at the bottom in a sub total and final cost line.

    My goal is to have the following happen. I would like to have the first page print out the same each time From $A$1:$F$42.
    Then a dynamic range between cells $A$44:$F$118 with only cells that have an entry in Column A being captured.
    And finally the last two lines of the spreadsheet $A$119:$F$120 at the end of the document regardless of how many entries are in the dynamic range.

    Reason being is from month to month I need to copy and past the previous months entries into tabs (which I deleted for this exercise) but the document will have 12 tabs for each month that link previous data to one another.

    This sheet has a few macros for hiding and unhiding column D, as well as an unprotect sheet, insert row below, copy formulas, and re-protect sheet macro.

    Can anyone guide me in combining all these things before I go crazy!!..

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Combination of fixed and dynamic print ranges

    Autofilter the second section to hide the rows with nothing in col A.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    12-29-2014
    Location
    Edmonton
    MS-Off Ver
    Office 2010
    Posts
    12

    Re: Combination of fixed and dynamic print ranges

    I'm really try to avoid having many steps, because multiple users of varying comforts are going to be using this template. I tried setting dynamic print ranges with the offset feature and it worked once, but when I add blank rows to make copying and pasting from one sheet to the next easier, it starts printing all the blank cells even though I used a countif statement. Is there another way to have this all done in the background?

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Combination of fixed and dynamic print ranges

    You're already using macros; use another to hide the rows you don't want printed.

  5. #5
    Registered User
    Join Date
    12-29-2014
    Location
    Edmonton
    MS-Off Ver
    Office 2010
    Posts
    12

    Re: Combination of fixed and dynamic print ranges

    I'm having trouble creating a macro that will hide and unhide blank rows based on empty rows in column A. Between A44:A118 I want to have a macro check for blank, then hide the rows with the sub-total and total rows being brought up to the next row. Then by pressing the button again it will unhide back to full blank rows. I'm a novice at best with Macros and the ones I have implemented have been forum copies or You Tube ideas. Any guidance on the VBA world would be appreciated. I think having these three buttons with these functions will cover what I need moving forward. If I can set a dynamic print range as well as the static first page range.

    Thank you

  6. #6
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Combination of fixed and dynamic print ranges

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    12-29-2014
    Location
    Edmonton
    MS-Off Ver
    Office 2010
    Posts
    12

    Re: Combination of fixed and dynamic print ranges

    That worked great. Thank you so much!

  8. #8
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Combination of fixed and dynamic print ranges

    You're welcome.

+ 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. [SOLVED] Dynamic Print Ranges
    By nunez100 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-21-2019, 02:24 PM
  2. Dynamic Multiple Print Ranges
    By slash_gnr3k in forum Excel General
    Replies: 2
    Last Post: 02-13-2014, 11:07 AM
  3. Code and Formula to print dynamic print area ranges
    By stpeter in forum Excel General
    Replies: 1
    Last Post: 10-15-2013, 03:33 PM
  4. Replies: 0
    Last Post: 07-12-2011, 02:25 PM
  5. Setting multiple dynamic print ranges
    By Masact in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-18-2008, 06:04 PM
  6. WHAT COMBINATION OF A SET OF NUMBERS COMES CLOSEST TO A FIXED NUMB
    By RED in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-05-2005, 02:06 PM
  7. [SOLVED] Fixed Ranges
    By Jeff in forum Excel General
    Replies: 1
    Last Post: 02-09-2005, 12:06 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