Copy complete row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hav a large data there is a way of copy a complete row if certain values
are in the rows
 
I hav a large data there is a way of copy a complete row if certain values
are in the rows
Click to expand...

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
__________________________
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Moving completed row to another worksheet 2
Macro to open CSV files 6
Can a row containing protected & unprotected cells be copied? 8
complex sort search and replace macro 2
2 formulas needed same workbook 15
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
auto filter on multiple rows 1

Back
Top