+ Reply to Thread
Results 1 to 4 of 4

Copying cells between two points

  1. #1
    Forum Contributor
    Join Date
    09-16-2004
    Posts
    100

    Copying cells between two points

    Ok, I might explain this horribly (apologies if so).

    What I've got is a sheet with a list of areas, then under each area, a list of teams and a total

    Example

    Area30

    Team1 - Count 4
    Team2 - Count 7
    Team3 - Count 5

    Sum - 16

    Area 36

    Team1 - Count 2
    Team4 - Count 6

    Sum - 8

    etc, etc.


    I need to copy parts of this sheet to another workbook, so for example, I want to find 'Area 36', and copy everything from the words 'Area 36' down to the 'Sum' underneath it.

    I've figured out how to search for the areas I want, but can't get my head around finding out where the 'Sum' underneath it is.

    Can anyone help? Happy to try and explain better if this is nonsense!

    Please Login or Register  to view this content.
    Last edited by arlu1201; 05-04-2012 at 07:22 AM. Reason: Code tags incorrect.

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    MS365 V.2406
    Posts
    2,317

    Re: Copying cells between two points

    Try this code on a copy of your workbooks...
    Please Login or Register  to view this content.
    Last edited by dangelor; 05-04-2012 at 08:59 PM.

  3. #3
    Forum Contributor
    Join Date
    09-16-2004
    Posts
    100

    Re: Copying cells between two points

    Dangelor,

    That's fantastic - I just needed to amend it to pull column C through as well (just used an offset on r2). Thanks a million, you've saved me potentially hours of tedious manual sorting per month!

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    MS365 V.2406
    Posts
    2,317

    Re: Copying cells between two points

    Glad it works!

+ Reply to Thread

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