If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Auto Populate Fields
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! |
#2
|
|||
|
|||
Excel Auto Populate Fields
Hi,
=IF((AND(Daily!C3:C101="William",Daily!B3:B101="Se t")),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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Rahn22" wrote: 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! |
#3
|
|||
|
|||
Excel Auto Populate Fields
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 "Shane Devenshire" wrote: Hi, =IF((AND(Daily!C3:C101="William",Daily!B3:B101="Se t")),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. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Rahn22" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|