Add new data and shift old data down.
 

I keep a running average of the last 100 grades in each subject. The data is
stored in a table 100 rows deep, with subject names across the top.

When someone completes a course, I want to add his grade to the top of the
data, have the last 99 grades shift downward one cell, and the 100th grade
delete, without having to cut and paste 99 cells at a time.

Is this possible?

Add new data and shift old data down.
 

right click on the row number where you want the new row eg2 and click insert
from the drop down menu. all data will then move down and give you a blank
row
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"pnbarbee" wrote:

I keep a running average of the last 100 grades in each subject. The data is
stored in a table 100 rows deep, with subject names across the top.

When someone completes a course, I want to add his grade to the top of the
data, have the last 99 grades shift downward one cell, and the 100th grade
delete, without having to cut and paste 99 cells at a time.

Is this possible?

Add new data and shift old data down.
 

I only update one column at a time, and inserting cells throws off formulas.

"john" wrote:

right click on the row number where you want the new row eg2 and click insert
from the drop down menu. all data will then move down and give you a blank
row
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"pnbarbee" wrote:

I keep a running average of the last 100 grades in each subject. The data is
stored in a table 100 rows deep, with subject names across the top.

When someone completes a course, I want to add his grade to the top of the
data, have the last 99 grades shift downward one cell, and the 100th grade
delete, without having to cut and paste 99 cells at a time.

Is this possible?