Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i copy rows using critera in a formula?
i need to know how to copy whole rows on to a diffrent sheet using critera in
a column for a formula so i dont have to look through 55 pages of data and copy what i want. |
#2
|
|||
|
|||
If I understand you correctly you may find that the Data Autofilter can help
( if you not sure how to use it visit http://www.auditexcel.co.za/dataclean.html ). If the criteria is explicit in one of the column of the row you can use the data autofilter directly. However, if there are a number of criteria that need to be met, set up another column with a formula that finds the rows you are looking for (e.g. if Column A AND column B are bigger than 10 then put the word CORRECT in the cell otherwise the word IGNORE). Then autofilter on this new column and copy the results. Hope this is what you were looking for. "tim_302ford" wrote: i need to know how to copy whole rows on to a diffrent sheet using critera in a column for a formula so i dont have to look through 55 pages of data and copy what i want. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display the max, then the next down, then the next down, etc. | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
How do you copy a formula without incrementing some constants? | Excel Worksheet Functions | |||
how can i copy formula? | Excel Worksheet Functions |