+ Reply to Thread
Results 1 to 9 of 9

Conditions & Populating

  1. #1
    Christy
    Guest

    Conditions & Populating

    I want to have a column that will populate another column in another sheet
    only IF a criteria is met. Is that possible?

  2. #2
    Guest

    Re: Conditions & Populating

    Hi Christy

    Do you mean the whole column populates at once depending on one cell, or
    each line populates in the column depending on a corresponding cell
    somewhere else?

    Andy.

    "Christy" <[email protected]> wrote in message
    news:[email protected]...
    >I want to have a column that will populate another column in another sheet
    > only IF a criteria is met. Is that possible?




  3. #3
    Ardus Petus
    Guest

    Re: Conditions & Populating

    Assuming your source data is in Sheet1,

    In "another sheet", enter formula:
    =IF(condition,Sheet1!A1;somevalue)
    where you replace condition by the appropriate formula, eg:
    =IF(Sheet1!A1>0;Sheet1!A1;"")

    HTH
    --
    AP

    "Christy" <[email protected]> a écrit dans le message de
    news:[email protected]...
    > I want to have a column that will populate another column in another sheet
    > only IF a criteria is met. Is that possible?




  4. #4
    Christy
    Guest

    Re: Conditions & Populating

    NO the whole column does not poulate at once. Basically what I'm creating si
    a sign-up form and when the information is entered, I need it to populate on
    other sheets that go to my company, supplier, etc. However, if some
    information equals "NO" then I don't want the info to poulate on the other
    sheet.

    Am I making sense? I really only have basic Excel knowledge that I've jsut
    elarned thru my own experience...

    Thanks for your help.

    "AndyB" wrote:

    > Hi Christy
    >
    > Do you mean the whole column populates at once depending on one cell, or
    > each line populates in the column depending on a corresponding cell
    > somewhere else?
    >
    > Andy.
    >
    > "Christy" <[email protected]> wrote in message
    > news:[email protected]...
    > >I want to have a column that will populate another column in another sheet
    > > only IF a criteria is met. Is that possible?

    >
    >
    >


  5. #5
    Guest

    Re: Conditions & Populating

    In that case, you can use a formula such as
    =IF(sheet1!A2="NO","",sheet1!B2)
    presuming your NO is in A2 and the value/text you want to copy over is in B2
    (both on sheet1)

    Andy.

    "Christy" <[email protected]> wrote in message
    news:[email protected]...
    > NO the whole column does not poulate at once. Basically what I'm creating
    > si
    > a sign-up form and when the information is entered, I need it to populate
    > on
    > other sheets that go to my company, supplier, etc. However, if some
    > information equals "NO" then I don't want the info to poulate on the other
    > sheet.
    >
    > Am I making sense? I really only have basic Excel knowledge that I've jsut
    > elarned thru my own experience...
    >
    > Thanks for your help.
    >
    > "AndyB" wrote:
    >
    >> Hi Christy
    >>
    >> Do you mean the whole column populates at once depending on one cell, or
    >> each line populates in the column depending on a corresponding cell
    >> somewhere else?
    >>
    >> Andy.
    >>
    >> "Christy" <[email protected]> wrote in message
    >> news:[email protected]...
    >> >I want to have a column that will populate another column in another
    >> >sheet
    >> > only IF a criteria is met. Is that possible?

    >>
    >>
    >>




  6. #6
    Christy
    Guest

    Re: Conditions & Populating

    MUCHAS GRACIAS!

    "AndyB" wrote:

    > In that case, you can use a formula such as
    > =IF(sheet1!A2="NO","",sheet1!B2)
    > presuming your NO is in A2 and the value/text you want to copy over is in B2
    > (both on sheet1)
    >
    > Andy.
    >
    > "Christy" <[email protected]> wrote in message
    > news:[email protected]...
    > > NO the whole column does not poulate at once. Basically what I'm creating
    > > si
    > > a sign-up form and when the information is entered, I need it to populate
    > > on
    > > other sheets that go to my company, supplier, etc. However, if some
    > > information equals "NO" then I don't want the info to poulate on the other
    > > sheet.
    > >
    > > Am I making sense? I really only have basic Excel knowledge that I've jsut
    > > elarned thru my own experience...
    > >
    > > Thanks for your help.
    > >
    > > "AndyB" wrote:
    > >
    > >> Hi Christy
    > >>
    > >> Do you mean the whole column populates at once depending on one cell, or
    > >> each line populates in the column depending on a corresponding cell
    > >> somewhere else?
    > >>
    > >> Andy.
    > >>
    > >> "Christy" <[email protected]> wrote in message
    > >> news:[email protected]...
    > >> >I want to have a column that will populate another column in another
    > >> >sheet
    > >> > only IF a criteria is met. Is that possible?
    > >>
    > >>
    > >>

    >
    >
    >


  7. #7
    Christy
    Guest

    Re: Conditions & Populating

    Okay, I tired and it didn't work. Me thinks I'm a trifle slow. Here's what I
    entered:

    IF(Departure Sign-up Sheet!O2="YES",'"Departure Sign-up Sheet!O2")

    I am putting this is the hotel sheet. I want the information from the
    Departure Sign-up Sheet to populate in the hotel sheet. Please let me know
    what I'm doing wrong.

    Thanks,
    Christy

    "Ardus Petus" wrote:

    > Assuming your source data is in Sheet1,
    >
    > In "another sheet", enter formula:
    > =IF(condition,Sheet1!A1;somevalue)
    > where you replace condition by the appropriate formula, eg:
    > =IF(Sheet1!A1>0;Sheet1!A1;"")
    >
    > HTH
    > --
    > AP
    >
    > "Christy" <[email protected]> a écrit dans le message de
    > news:[email protected]...
    > > I want to have a column that will populate another column in another sheet
    > > only IF a criteria is met. Is that possible?

    >
    >
    >


  8. #8
    Ardus Petus
    Guest

    Re: Conditions & Populating

    Since your Worksheet name contains spaces, you must surround it with '
    (single quotes)

    IF('Departure Sign-up Sheet'!O2="YES",'Departure Sign-up Sheet'!O2")

    HTH
    --
    AP

    "Christy" <[email protected]> a écrit dans le message de
    news:[email protected]...
    > Okay, I tired and it didn't work. Me thinks I'm a trifle slow. Here's what

    I
    > entered:
    >
    > IF(Departure Sign-up Sheet!O2="YES",'"Departure Sign-up Sheet!O2")
    >
    > I am putting this is the hotel sheet. I want the information from the
    > Departure Sign-up Sheet to populate in the hotel sheet. Please let me know
    > what I'm doing wrong.
    >
    > Thanks,
    > Christy
    >
    > "Ardus Petus" wrote:
    >
    > > Assuming your source data is in Sheet1,
    > >
    > > In "another sheet", enter formula:
    > > =IF(condition,Sheet1!A1;somevalue)
    > > where you replace condition by the appropriate formula, eg:
    > > =IF(Sheet1!A1>0;Sheet1!A1;"")
    > >
    > > HTH
    > > --
    > > AP
    > >
    > > "Christy" <[email protected]> a écrit dans le message de
    > > news:[email protected]...
    > > > I want to have a column that will populate another column in another

    sheet
    > > > only IF a criteria is met. Is that possible?

    > >
    > >
    > >




  9. #9
    Christy
    Guest

    Re: Conditions & Populating

    Thanks, I finally got it to work. I appreciate the help.

    "Ardus Petus" wrote:

    > Since your Worksheet name contains spaces, you must surround it with '
    > (single quotes)
    >
    > IF('Departure Sign-up Sheet'!O2="YES",'Departure Sign-up Sheet'!O2")
    >
    > HTH
    > --
    > AP
    >
    > "Christy" <[email protected]> a écrit dans le message de
    > news:[email protected]...
    > > Okay, I tired and it didn't work. Me thinks I'm a trifle slow. Here's what

    > I
    > > entered:
    > >
    > > IF(Departure Sign-up Sheet!O2="YES",'"Departure Sign-up Sheet!O2")
    > >
    > > I am putting this is the hotel sheet. I want the information from the
    > > Departure Sign-up Sheet to populate in the hotel sheet. Please let me know
    > > what I'm doing wrong.
    > >
    > > Thanks,
    > > Christy
    > >
    > > "Ardus Petus" wrote:
    > >
    > > > Assuming your source data is in Sheet1,
    > > >
    > > > In "another sheet", enter formula:
    > > > =IF(condition,Sheet1!A1;somevalue)
    > > > where you replace condition by the appropriate formula, eg:
    > > > =IF(Sheet1!A1>0;Sheet1!A1;"")
    > > >
    > > > HTH
    > > > --
    > > > AP
    > > >
    > > > "Christy" <[email protected]> a écrit dans le message de
    > > > news:[email protected]...
    > > > > I want to have a column that will populate another column in another

    > sheet
    > > > > only IF a criteria is met. Is that possible?
    > > >
    > > >
    > > >

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1