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! 
Bookmarks