VGA Neophyte: Help making a single button to save as and, print pages 1-N, as based off of cell values.

PDT Inc

New Member
Joined
Aug 6, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
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!
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,129,515
Messages
5,636,790
Members
416,941
Latest member
shazzaxyz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top