Okay, I know there are a number of similar questions out there but I didn't find any that addressed the print pages 1-N specifically.
What I have is a tool I have put together to record special order packing slips for our shipping department.
I have the save file name being compiled by a formula located at X4 (this should save as a .xlsm file) and the formula for the last page number that needs to print at X8. In case it's useful to the
X4: utilizes a formula to compile information from other cells to make the file name
=SUBSTITUTE((PROPER(C6&"_"&C7))," ","")
X5: Since 3 slips fit on each page, this formula counts the total number of entries and divides by 3, to get the total number of pages needed for the print, 1-N
=ROUNDUP(((COUNTA($G$4:$G$33)+(COUNTA($P$4:$P$33))))/3,0)
Apologies, if I confused the issue or my formatting is a hassle. I greatly appreciate any help that you can give.
Thank you!
What I have is a tool I have put together to record special order packing slips for our shipping department.
I have the save file name being compiled by a formula located at X4 (this should save as a .xlsm file) and the formula for the last page number that needs to print at X8. In case it's useful to the
X4: utilizes a formula to compile information from other cells to make the file name
=SUBSTITUTE((PROPER(C6&"_"&C7))," ","")
X5: Since 3 slips fit on each page, this formula counts the total number of entries and divides by 3, to get the total number of pages needed for the print, 1-N
=ROUNDUP(((COUNTA($G$4:$G$33)+(COUNTA($P$4:$P$33))))/3,0)
Apologies, if I confused the issue or my formatting is a hassle. I greatly appreciate any help that you can give.
Thank you!
