Selecting ranges to copying and Paste

  • Thread starter Thread starter Marcus
  • Start date Start date
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto Copy Data from one worksheet to another 1
Copy columns and paste with blank column between 5
Code copies twice...? 13
Eliminate blanks while copy row and transpose 11
Copy row info but not in normal column sequence 6
ERROR 400 on identical codes different range 8
Looping through HTML table to populate Excel 6
Pivotting? Transposing? Normal Forming? Crosstabbing? 3

Back
Top