DutchMonkey
New Member
- Joined
- Jan 19, 2021
- Messages
- 3
- Office Version
- 365
- 2010
- Platform
- Windows
I have a spreadsheet that I am re-building for use with our customers. They enter in data parameters and we provide the quotation based upon what they provide.
However, their order sizes range from 2 - 20 all the way up to the hundreds and occasionally thousands.
I also use this as an instructional sheet for our assembly team. But in order to print I have to go through a series of "highlight area, print selection,..." etc. due to the hundreds of blank spaces that are being included in the initial print view.
Is there a way to automatically size the sheet when they enter the # of assemblies they are listing? The goal being to trim the "miles" of excess blank formatted pages without having to do it manually every time.
Caveat: I am mostly self taught with Excel and know the BARE MINIMUM on VBA so I will definitely need some guidance!
However, their order sizes range from 2 - 20 all the way up to the hundreds and occasionally thousands.
I also use this as an instructional sheet for our assembly team. But in order to print I have to go through a series of "highlight area, print selection,..." etc. due to the hundreds of blank spaces that are being included in the initial print view.
Is there a way to automatically size the sheet when they enter the # of assemblies they are listing? The goal being to trim the "miles" of excess blank formatted pages without having to do it manually every time.
Caveat: I am mostly self taught with Excel and know the BARE MINIMUM on VBA so I will definitely need some guidance!