Selecting ranges to copying and Paste

M

Marcus

I am sure this possible, could some please help

I am trying to copy ranges of data from one work sheet to
another using VBA but only when the data meets certain
criteria see below
i.e
column 1 column 2
Florida
div 4 New York

Leeds
London
Birmingham
div 1

I want to copy data leeds london and birmingham if column
1 = Div 1 but stop copying when div 2 or 4 appears in
column 1.

Many Thanks
Marcus
 
Top