So what I am trying to do is jump to the bottom of a table, then go down two cells and enter SUBTOTAL for all values above. I noticed when I just Ctrl down arrow, then press down twice, the code that comes up looks like it does jump to the bottom, but when I press the down arrow twice, it then specifically chooses that cell as the starting point. Since each day the row number that this table goes down to changes, it needs to not choose the specific cell that I down arrow to, but just jump down to the bottom of the data, then select whatever cell is two below that. Does this make sense?
Thanks!
Bookmarks