| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create an equation to copy a row of data from one worksheetto another if it meets certain criteria
Currently I have a work book with lots of data in it that im trying to make a little easier to manage.
The logic im trying to use goes along the lines of If worksheet 1 f2,F809 = W1 then copy that row into worksheet 2. If it doesn't then check the next row. Is this possible at all? I did have a rudimental equation but I cant figure out the copy part of it. I also need this to be copied down the coloum in the second worksheet. The equation I have so far is =IF('W1'!F2:F28="W1","copy row","") Obviously this hasn't worked. Any help would be appreciated |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count data that meets more than one criteria? | Excel Discussion (Misc queries) | |||
| SUM data if meets criteria | Charts and Charting in Excel | |||
| Copy row details where cell value meets certain criteria | Excel Worksheet Functions | |||
| copy row to new sheet where cell value meets criteria | Excel Discussion (Misc queries) | |||
| Get data if cell within a row meets criteria | Excel Discussion (Misc queries) | |||
Threaded Mode
