Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically Append New Data in Unknown Addresses into Existing Ranges
This is baffling...I want to Excel to automatically include new columns
added in a sheet into previously named ranges. The defined ranges are currently named with the same names as the column headings. In a separate sheet, there are 5 different types of columns that are pre-formatted 'template' columns. This is a school spreadsheet; so in a Grades sheet, teachers can press buttons to insert the different columns as needed for each new day. The columns' headings are on row 12 and a Attendence, Performance, Behavior, Notes, and Assignments. The reason for doing this is because there can be several columns for "Assignments" each day--one to record quiz scores, another to record homework scores, etc. Also, the columns will be in no set order. Instead of a teacher having to select each and every column to be included in a particular range, like for the Assingments =Grades!$AN:$AN,Grades!$AG:$AI, is there a way for Excel to do this automatically? row 11 1/3/07 | 1/10/07 | 1/12/07 row 12 Assignment | Notes | Assignment row 13 Math puzzle | | Open quiz row 15 10 points | The student... | 95 pts etc. Any insights would be greatly appreciated. Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unknown email addresses | Excel Discussion (Misc queries) | |||
Simple code to append numbers to the existing data in the cells | Excel Programming | |||
Append columns to existing worksheet? | Excel Programming | |||
How do I paste to append instead of replace existing data? | Excel Discussion (Misc queries) | |||
How to append existing series? | Charts and Charting in Excel |