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.

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.