Results 1 to 5 of 5

Detecting where to Insert, Delete, or Rearrange Rows using Values and Dates

Threaded View

  1. #1
    Registered User
    Join Date
    07-12-2010
    Location
    Midwest, US
    MS-Off Ver
    Excel 2007
    Posts
    13

    Detecting where to Insert, Delete, or Rearrange Rows using Values and Dates

    Hi Programmers,
    I'm a kid teacher and want to outline my lesson plans in Excel. I'm planning a new class and am anticipating not being able to accomplish everything planned for a lesson; thus needing to do those things the next day. Therefore, it'd be great, say, if there could be a way to auto-rearrange certain lesson items outlined for today and insert them in tomorrow's set of rows--but this brings up some other issues...

    Attached is a sample worksheet. Here are some assumptions:
    --Different days or lessons will have a different number of rows.
    --A lesson outline contains 8 parts: Title, Objectives, Topics, Materials, BellWork, Activities, Homework, and Assessment.
    --Different lessons will have different numbers of rows (LESSONITEMS) in these parts (LESSONPARTS).
    --Daily lessons are separated by a blank row.

    Cells in Col C for instance, named CTRL, are where it would be great to do the following:
    When clicked, pop-up a window with the following options:
    1. Copy the LESSONITEM to the first row of tomorrow's same LESSONPART (if not blank), bumping the rest down.
    2. Copy the LESSONITEM and the rest of the items for that LESSONPART to the first row of tomorrow's same LESSONPART, bumping the rest down.
    3. Reorder the LESSONITEM with the LESSONITEM above (if the cell above is not blank or have a different LESSONPART in col D)
    4. Reorder the LESSONITEM with the LESSONITEM below (if the cell below is not blank or have a different LESSONPART in col D)
    5. Copy the entire lesson (all LESSONPART LESSONITEMS) to a particular weekday (entered in col B; maybe open a calendar for the user, which will ripple the other lessons down to the next weekday)
    6. Add a new lesson for this date (applies to days lacking lesson plans in row 285 and down; this would copy the template in the LESSONTEMPLATE sheet and insert it for that day)

    Note that the original way to insert and delete rows in Excel should still be possible.

    Here is the list of col headings:
    A = WEEK
    B = DATE
    C = CTRL
    D = LESSONPART (subparts = Title, Objectives, Topics, Materials, Bellwork, Activities, Homework, and Assessment)
    E = LESSONITEM
    F = ITEMINFO
    G = XTRAINFO
    H = REVIEW Y/N
    I = DELETE Y/N

    I realize this may be hard to do; just wishful I guess. Any attempt at this, or an improvement, would be greatly appreciated, as this stuff is beyond me.
    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1