| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA
I have a set of data that contains:
- 10 rows that start with 001 - 10 rows that start with 002 - 10 rows that start with 003. How should the macro be written to find only the rows that start with 002 and copy those to another spreadsheet? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel VBA
for each cell in Range("A1:A30")
if cell.Text = "002" then Next also, if you are copying or something: Perhaps something on this page http://www.rondebruin.nl/copy5.htm at Ron de Bruin's site -- Regards, Tom Ogilvy -- Regards, Tom Ogilvy "gregory" wrote: I have a set of data that contains: - 10 rows that start with 001 - 10 rows that start with 002 - 10 rows that start with 003. How should the macro be written to find only the rows that start with 002 and copy those to another spreadsheet? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
