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
__________________________
