| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
skip rows depending value of a particular cell in that row
I have a workbook with data elements in column A to F and about 1500 rows
(will increase). Column D sometime has the value "not assigned". I would like to get subset of the data by leaving "not assigned" rows out. I have written code to look at each from row 1 to end to check for "not assigned" in column D and drop that row. It work but takes a while to run and as the file will be getting larger with time it willl take longer. Can anyone help with more efficient code? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MACRO PASTE CELL to COLUMN, SKIP ROWS | Excel Discussion (Misc queries) | |||
| Concatenate Rows depending on cell value in rows | Excel Programming | |||
| Delete rows depending on cell Value | Excel Programming | |||
| adding rows depending on cell value | Excel Worksheet Functions | |||
| conditional formating on rows & cols depending on one cell | Excel Discussion (Misc queries) | |||
Threaded Mode
