Selecting ranges to copying and Paste
 

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

Selecting ranges to copying and Paste
 

Hi
see Ron's site for some examples:
http://www.rondebruin.nl/copy5.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Marcus wrote:
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