![]() Note that the macro will overwrite any information already on Sheet2. ![]() J = 1 ' Start copying to row 1 in target sheetįor Each c In Source.Range("E1:E1000") ' Do 1000 rows Set Target = ActiveWorkbook.Worksheets("Sheet2") Set Source = ActiveWorkbook.Worksheets("Sheet1") ' Change worksheet designations as needed The following macro examines the first 1,000 rows of Sheet1 and copies to Sheet2 any rows containing "yes" in column E. If you have to do the task more often, you could create a macro to make the copying a snap. Copy the visible rows and paste them into whatever worksheet you want. Turn on filter and filter your data so it only shows rows that have "yes" in column E. ![]() If you only need to do this type of task sporadically, then you can simply use the filtering capabilities of Excel. ![]() Vlookup doesn't seem to work for this type of evaluation. Marian wonders if there is a way to copy an entire row from one worksheet to another worksheet based on the occurrence of a specific text value ("yes") in column E of the row.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |