Copy row details where cell value meets certain criteria

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

Guest

I want to be able to copy (from one worksheet to another) all the cells in
row37 (up to column R) where the value in R37 is greater than 6000.

I'm thinking a vlookup function (or similar) would be the way to go, but I'm
not quite sure.

Any ideas?
 
I should probably revise what I previously wrote (sorry):

I want to be able to copy (from one worksheet to another) all the cells IN
ANY ONE ROW (e.g. row 37) out of about ~200rows, where the value in column R
is greater than 6000.

Sorry for the confusion.
(thanks for the quick response tho!)
 
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

Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Identifying the # of cells containing data 3
CountIf previous cell formula 0
Match Criteria & Return Sequential Count 8
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
copy rows to new sheet based on specific cell value 4
Summing a range of cells with criteria 7
Changing Cell Color Based on Value 2

Back
Top