| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to find common strings of text then copy those rows elsewh
Well spotted thanks for the correction
"Gord Dibben" wrote: Alt + F11 to open the Visual Basic Editor. CTRL + r to open the Project Explorer. Select your workbook(project) and right-clickInsertModule. Paste the code into that general module. Do not paste it into the Thisworkbook module as Mike suggests. Thisworkbook module should be reserved for event code, not general macros. As an alternative.........have you looked at DataFilterAutofilter? Gord Dibben MS Excel MVP On Sun, 20 Apr 2008 08:14:00 -0700, energyzone wrote: Thanks! Unfortunately I know nothing about macros. When I click on This Workbook, all my rows are displayed. Does it matter where I copy the material you gave me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| common characters in seperate strings | Excel Discussion (Misc queries) | |||
| How to find and highlight common text in multiple columns | Excel Discussion (Misc queries) | |||
| How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
| Excel find text and copy rows | Excel Discussion (Misc queries) | |||
| Copy Rows found using Find All feature | Excel Discussion (Misc queries) | |||
Threaded Mode
