| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
VBA code to select rows
Hi
I want to write a vba code in "Sheet2", to select rows from "Sheet1" based on my condition and then paste those rows in defined range in "Sheet2" Example I want to select rows in sheet1 where the condition is that cell value c3=d3, I have 500 rows. Now the rows that meet the condition, I want them to be displayed in sheet 2 in the cell range starting from a20 to a2000 Please advise |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to Auto Select OK when an Option Box Appears | Excel Discussion (Misc queries) | |||
| How can i randomly select 780 rows from 4000 rows of data | Excel Worksheet Functions | |||
| Code to select range | Excel Discussion (Misc queries) | |||
| Select sheet with VB code | Excel Discussion (Misc queries) | |||
| Unable to select rows in the repeat rows on top option | Excel Discussion (Misc queries) | |||
Threaded Mode
