| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
if i select a cell then i want row containing that cell selected
i want to copy all rows that contain a cell with certain value.
|
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
if i select a cell then i want row containing that cell selected
Do a Data Filter Autofilter on the key col,
filter out that certain value, then copy the filtered rows, and paste special as values/formats elsewhere as required -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Maaz" wrote: i want to copy all rows that contain a cell with certain value. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change cell text based on another selected cell? | Excel Discussion (Misc queries) | |||
| how do I insert the address of a selected cell into a fixed cell | Excel Discussion (Misc queries) | |||
| A formula for displaying the cell reference of the selected cell | Excel Discussion (Misc queries) | |||
| automatic offset cell location when there is a value in a selected cell. | Excel Worksheet Functions | |||
| how read value from last selected cell? It is possible? how get adress last selected cell? | New Users to Excel | |||
Linear Mode
