Here is what I am trying to do:
https://drive.google.com/file/d/0Bz8...it?usp=sharing
I know the CountA formula to be =Counta(A1:AXX) will do what I want as I used it in the pages above. I've been trying to come up with the code that will automatically place that formula in the corresponding "H" row of the last line in the page. I've tried going off of some other page break code but can't seem to get it to work. Here is the code Im currently using:
This is a call log I made for my job. Whenever data is input to column A the time-stamp will reflect in column G automatically. If the entry is removed from Column A, the time stamp is then removed from column G. Then when you press "Enter" or "Tab" it will move to the next column instead of row. Once it gets to Column F, pressing enter or tab will return you to A column in the next row. It's very handy and this last little thing would make it perfect. Thanks!
Bookmarks