Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy complete row
I hav a large data there is a way of copy a complete row if certain values
are in the rows |
#2
|
|||
|
|||
Copy complete row
On Thu, 27 Oct 2005 10:03:05 -0700, "Joel"
wrote: I hav a large data there is a way of copy a complete row if certain values are in the rows Difficult to know exactly what you're trying to do from the limited comment above, but you could try filtering your data set on the column containing the values you're interested in. Then just copy and paste. If the value could be in any column, you could try using a helper column with an =Match(yourvalue,false) function, then filter on that column for non errors. HTH. __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy tabs(sheets) from workbook without link to original source | Excel Discussion (Misc queries) | |||
How can I copy cell formats in functions? | Excel Worksheet Functions | |||
Copy sheet 1 data to sheet 2 cells. | Excel Worksheet Functions | |||
Copy without Hidden Cols - How | Excel Discussion (Misc queries) | |||
INDIRECT Function impact on Copy Worksheet | Excel Worksheet Functions |