Copy row details where cell value meets certain criteria
 

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?

Copy row details where cell value meets certain criteria
 

=IF(Sheet1!A37="","",Sheet1!A37)
copy across

"Sarah (OGI)" wrote:

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?

Copy row details where cell value meets certain criteria
 

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!)

"Teethless mama" wrote:

=IF(Sheet1!A37="","",Sheet1!A37)
copy across

"Sarah (OGI)" wrote:

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?