| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter function; copy values to another sheet
Hi,
I'm looking for a way to do the following: I have a sheet with (100) rows; in colom A there are values that are not unique. The word "apple" kan appear three times, for example. In colom B there are also values, as much as there are in colom A. What I want is the following: a macro that searches for the word (for example) "apple" and copies the values from the row in colom B to another sheet, range D1. Any help would be appriciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy/filter data in a sheet from another sheet | Excel Discussion (Misc queries) | |||
| Filter function; copy values to another sheet | Excel Discussion (Misc queries) | |||
| 'Copy to' Advance Filter depend only on sheet ID not start sheet | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Worksheet Functions | |||
| copy values generated by conditional formula in one sheet to the other work sheet as values | Excel Discussion (Misc queries) | |||
Threaded Mode
