I am working with two seprate worksheets. There is Data on one sheet that I
will manually input, what I want to do is have that data move from worksheet
1 to worksheet two (in a desgnated cell) once two critirias are met in two
seprate cells.

For expamle:

When William makes a Sale, I want the name of the Company to be copied from
the list on worksheet 1. Sinc eI have Mark and William, I only want the data
from William to move and only if one cell says "Set" and another Says "Sale".

This is the formula I used:
=IF((AND(Daily!C3:C101="William",Daily!B3:B101="Se t")),Daily!A3:A101)

The only thing this will do is come back with a False.

I know that I can do it if I am just looking for one critria to be met, but
how do I do it if there are multi critiria to be met?

Also, does it matter if I use a drop down menu to fill in those two seprate
fileds.

I would be more than happy to send someone the file if they need to look at
it.

I need help!