I'm working on a an electronic coaching log where conversations and observations are transcribed. Depending on the coach and the length of the visit, the log can be two pages or twenty pages. These logs need to have the ability to be printed out easily and the # of pages is tracked for research purposes. Right now, I'm using this code that requires a button and that the macro is run after the data has been entered:
I've attached the file and as you can see, it's not working correctly. What I really want is for the number of pages to be calculated automatically when the document is printed or saved and I want the print area to adjust to whatever the end of the table is. I hope this makes sense.
Thank you!
L
Bookmarks