I am trying to design a travel form for some staff members to use. Some members will only have a few rows of travel to enter while other members may have up to 200 rows. I need to have a line at the end that will show the total miles and total reimbursement amount. The form needs to be set up to only print the rows that they enter information on.
Most of the staff members are not "tech savvy" and will not understand filtering out the blank lines. We are also not allowed to use macros. I have tried experimenting with different setups with Excel spreadsheets and tables but I can't solve the printing issue - I always end up with 7 pages even if there is only user data on page 1. Does anyone have any ideas or suggestions? What is the best way to do this? Can it be done without macros? Thank you!