| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy row to new sheet where cell value meets criteria | Excel Discussion (Misc queries) | |||
| How can I get a cell to Flash if it meets a certain criteria in Ex | Excel Worksheet Functions | |||
| How do I go to the next cell that meets criteria | Excel Discussion (Misc queries) | |||
| Get data if cell within a row meets criteria | Excel Discussion (Misc queries) | |||
| how do I change the font of a cell if it meets a certain criteria. | Excel Worksheet Functions | |||
Hybrid Mode
