PDA

View Full Version : Moving an Entire Line using ActiveCell.Row



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

Bob Phillips
01-15-2009, 10:44 AM
Did you post the correct file? Nothing on line 64.

IcePirates
01-15-2009, 10:46 AM
My bad...Which ever line 63 (it might be?)
Where it says "Total UseD" and it has totals across the row(S)

Bob Phillips
01-15-2009, 10:52 AM
Can't see that anywhere.

IcePirates
01-15-2009, 10:53 AM
Hmm, here it is again!

Thanks for looking into this!

Line 64

IcePirates
01-15-2009, 11:02 AM
Ok, I figured out how to get the rows to add by double clicking

Now what I need to do, is not have any of the formula's effected by adding a line, as a matter of fact, if someone adds a line and enters new information on that row...I need it to calculate in the 'Totals Area'

Take a look at the attached.

For example, if you added a row, then in Column C row 62 if you added a 2
I need it to calculate in the totals at the bottom...

Let me know your thoughts

Bob Phillips
01-15-2009, 11:10 AM
That looks nothing like thefile you originally posted.

If you don't help yourself, you cannot expect help from us.

IcePirates
01-15-2009, 11:12 AM
Sorry about that!