Results 1 to 11 of 11

Inserting A selection before another

Threaded View

  1. #1
    Registered User
    Join Date
    01-11-2005
    Posts
    24

    Inserting A selection before another

    The task that I wish to complete is not a simple one for me, maybe I can ask one of you veterans how to do it.

    My problem is this, I have a group of cells, say A1 to D5. I need to take this selection and paste them into a new area near the bottom of the sheet before a "Summary" set of rows. So to attempt to show you what I need to do.
    ____A_______B_________C__________D_______
    1 |Project #|Priority #|People involved|Hours worked|
    2 |________|_______| Name_______|___ 7 ______|
    3 |________|______ | Name _______|___ 4 _____|
    4 |________|______ | Name _______| ___ 3 _____ |
    5 |________|_______| Name_______|____ 7_____ |
    6 Need to take selection and "copy and insert" here
    7 ____________________________________________
    8 |________|________|___Summary__| Total hours ___|
    9 |________|________|Name________| hours________|
    10 |________|________|Name________| hours________|
    11 |________|________|Name________| hours________|
    12 |________|________|Name________| hours________|

    Just normally copying is easy, inserting at the bottom before the Summary is easy, that is if you do it manually.

    I am attempting to set up a macro that will check the columns and insert it automatically. I was thinking of either checking the "C" column and inserting the selection right after it or searching the sheet for the word "Summary" and inserting the selection right above it. I just don't know how to set up the macro to do it for me.

    An entirely seperate problem that I will be having next is, how do I get the "total hours" column to update to include the hours of the newly inserted rows?

    Any help is apprieciated and please excuse my horrible art

    Link S
    Last edited by Link Strife; 01-11-2005 at 06:59 PM.

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