Thread: Copy row details where cell value meets certain criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default 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?
Reply With QuoteReply With Quote