You could do this by using a filter and manually copying the filtered
rows across to another sheet. For example, filter the column for HIRE
and only those records will be displayed. Then highlight the record(s)
you want to copy to another sheet, click <copy, select the other
sheet, move curso to the appropriate cell and <paste - only the
visible row(s) selected will be copied into this sheet.

In Ruth's case, she would have to apply a Custom filter on column A -
equal to Dog OR equal to CAT, then copy/paste as described.

Hope this helps.

Pete

twmmyv wrote:
I am also needing help on this. I have a log that I keep of new hires. I have
to log all applicants. I need for the employee info to copy over to a
different worksheet. example: if a cell has HIRE in it on tab applicant, I
need that line to copy over to new hire.

"Dave F" wrote:

To do what you're looking to do, you would have to use VBA code.

Your logic would be =IF(OR(A1="dog",A2="cat"),[copy row],[do nothing])

But as I say you can't do this if you want to stick to very basic
functions/formulas.

Dave
--
Brevity is the soul of wit.


"Ruth_J" wrote:

Hi,
Help pls... I'm only familiar with very basic functions/formulas in Excel
2003. I need to copy an entire row from one wrkbk/wrksht to another
wrkbk/wrksht based on the criteria in two individual cells in that row. (If
A1=dog or A2=cat in wrkbk1 sheet1, then copy entire row to wrkbk2 sheet1)

The original worksheet data is updated daily. Format, header, columns, etc.
never changes.

Thanks for your help,
Ruth