| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Shift effieceincy data | Charts and Charting in Excel | |||
| Macro to shift all source data in a chart by one row or column? | Charts and Charting in Excel | |||
| Why does the data shift out my outline when I refresh the Pivot table? | Excel Worksheet Functions | |||
| How can I shift my data line to the left? | Charts and Charting in Excel | |||
| Import Data: on insert, shift data down and not right | Excel Discussion (Misc queries) | |||
Threaded Mode
