Excel Auto Populate Fields

[Rahn22]

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="Set")),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!

 

[Shane Devenshire]

Hi,

=IF((AND(Daily!C3:C101="William",Daily!B3:B101="Set")),Daily!A3:A101)

You are not looking at one cell here but an entire range. Where is this
formula - in one cell or a whold column of cells? What do you want the
formula to do if C6 says William and B6 says Set AND C3 says Shane and B3
says Set? If C3 is William and B3 is Set what do you want your formula to do
with all the cells A3:A101? SUM them find the max, the min?

All your FALSE means is that C3 is not William and/or B3 is not Set.

 

[Rahn22]

Thank you for the help Shane. Let me explain what I am trying to do ( I know
it was confusing! LOL)

Cells C3-C101 have the reps name
Cells B3-B101 show if the call was Set, Not Interested or Needs more info
Cells A3-A101 show the company name
All of these cells are in Worksheet named Daily. As I call through the list
of companies (Cells A3-A101) and make an appointment (Cells B3-B101 "Set")
for William or Mark (Cells C3-C101), I want the name of the company to be
copied from Worksheet "Daily" to Worksheet "Weekly".

What I did was wrote the formula in the "Weekly" Worksheet Cell that I want
the Company name populated in. Then I just copied that formula and placed it
into the next 101 cells in the row that the original cell is in.

Ultimately, I will copy the correct formula and place them in other cells to
pull more info from worksheet "Daily" into worksheet "Weekly" as needed. I
want to get it right first though.

also, I am not sure if it matters that the Reps name (C3-C101)and the
disposition (Cells B3-B101 ) are all populated via a drop down menu I
created. Not sure if it matters, just wanted to let you know.

If you like I could send you the whole workbook if it would help.

-Ron