Copying cells between two points

[madbloke]

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.

[dangelor]

Try this code on a copy of your workbooks...

Please Login or Register  to view this content.

[madbloke]

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!

[dangelor]

Glad it works!