PDA

View Full Version : Print title + Dynamic range until empty row



JVAII
09-30-2015, 10:42 AM
Hello everybody,


I'm doing a colleague a favor by looking into a VBA formula to make her reporting tasks a little easier, poor her, but I need help myself now.


this is how her tabsheet is set up:


14475


this is how the end result should look like in the printer tray:


14476

14477
some facts:


- the values in column B ("APE", "APF", ...) are the 'seperators'. I tried to define a loop where the module selects the data until it finds an empty row, but there are 2 empty rows for each value in column B (e.g. for APE = row 7 & row 11) and it got me confused.
- the number of rows that need to be printed on a seperate page are dynamic: e.g. for B5 = "APE", one day it's 2 persons, the other day it's more or less than 2.
- the title in cell D2 should show on each page
- the number of columns doesn't change


Could use the help, thanks in advance!

SamT
09-30-2015, 03:53 PM
:dunno It sure looks to me like the "Separators" are in Column A.

Why do you need to print the note about titles on each printed page? BTW, where are the Titles that must be printed on each page?

Is it ever possible that there will be enough entries in Columns B & C that it will require more than one printed Page?

p45cal
09-30-2015, 04:02 PM
cross posted:
https://www.daniweb.com/programming/software-development/threads/500171/print-title-dynamic-range-until-empty-row
http://www.excelforum.com/excel-programming-vba-macros/1106764-print-title-dynamic-range-until-empty-row.html

before anyone sets to work on a solution, check the above (excelforum already has an offered solution).

JVAII, you should really provide these cross post links yourself… why? See http://www.excelguru.ca/content.php?184