| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Copying row into new sheet if it contains certain text
Hi,
I've seen threads similar to this before, however I don't know much about macros so I'm having trouble translating similar macros into one that fits the column/cell/sheet names as mine. So in Sheet1 of my file I want to copy out all rows that contain "Milka" in column I. This column contains other names in each cell, but I just want to take out ones that contain Milka (can contain other names also). And I want to copy these rows into Sheet 5. Any help from you excel geniuses would be much appreciated! :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying text on sheet 1 to corresponding cells on sheets 2 to 5 | New Users to Excel | |||
| copying data from text file to excel sheet | Excel Programming | |||
| Copying cells from on sheet to another sheet (via sheet module) | Excel Programming | |||
| Long Text in merged cells not copying correctly with sheet | Excel Programming | |||
| Copying text from a text box into a cell on another sheet | Excel Programming | |||
Threaded Mode
