IcePirates
01-15-2009, 10:13 AM
I have an Excel sheet and on line 64 sits the totals from the columns and rows above it...
If a user is inputting information on line 62, then hits enter on his keyboard to go to line 63, I want the "Totals Line" to move from 64, down to 65...If the the user is on line 63 and inputs information, then hits enter, I want the totals line to move from 65 to 66...
And so on and so on, but all the while still calculating the totals on the 'Totals' line...
Is this possible, using ActiveCell.Row if so how?
I attached an example of my work-book
If a user is inputting information on line 62, then hits enter on his keyboard to go to line 63, I want the "Totals Line" to move from 64, down to 65...If the the user is on line 63 and inputs information, then hits enter, I want the totals line to move from 65 to 66...
And so on and so on, but all the while still calculating the totals on the 'Totals' line...
Is this possible, using ActiveCell.Row if so how?
I attached an example of my work-book