R
Ray
I searched for 'Dynamic Print Area' and, to my surprise, got
absolutely no results. I can't imagine that I'm the first to ask
this, but I've no idea how to re-word it to get results ...
I have a worksheet that users need to print every day -- problem is
that some days, the sheet could have 3015 lines (or more) and other
days, only have 1005 (or less). The number of rows is dictated by how
many cashiers worked the previous day, with each cashier entry being
67 lines long.
My specific questions are:
1) How can I set the print_area to recognize what the bottom row is
and set the print_area accordingly?
2) Each page needs to contain all data for just one cashier ... that
is, 67 lines per page. Entries start in row 3 ...
Good to know info:
A) this sheet is actually one of many in the workbook (all will be
printed) ... it's just the only one that needs a dynamic print_area.
B) users may print from a Button I've inserted OR the default Excel
Print button -- ideally, the solution here will work either way.
Thanks alot for your time on this ... a successful solution will help
save multiple REAMS of paper each day (FYI, I'm attempting to move
this to a paper-less solution but our auditors aren't keen on that).
Regards, Ray
absolutely no results. I can't imagine that I'm the first to ask
this, but I've no idea how to re-word it to get results ...
I have a worksheet that users need to print every day -- problem is
that some days, the sheet could have 3015 lines (or more) and other
days, only have 1005 (or less). The number of rows is dictated by how
many cashiers worked the previous day, with each cashier entry being
67 lines long.
My specific questions are:
1) How can I set the print_area to recognize what the bottom row is
and set the print_area accordingly?
2) Each page needs to contain all data for just one cashier ... that
is, 67 lines per page. Entries start in row 3 ...
Good to know info:
A) this sheet is actually one of many in the workbook (all will be
printed) ... it's just the only one that needs a dynamic print_area.
B) users may print from a Button I've inserted OR the default Excel
Print button -- ideally, the solution here will work either way.
Thanks alot for your time on this ... a successful solution will help
save multiple REAMS of paper each day (FYI, I'm attempting to move
this to a paper-less solution but our auditors aren't keen on that).
Regards, Ray