| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting mutliple ranges | Excel Worksheet Functions | |||
| help with copying multiple ranges and paste it on a work sheet based on conditions | Excel Discussion (Misc queries) | |||
| V.B selecting ranges for naming | Excel Programming | |||
| Selecting Named Ranges | Excel Programming | |||
| selecting ranges | Excel Programming | |||
Linear Mode
