I want to have a column that will populate another column in another sheet
only IF a criteria is met. Is that possible?
I want to have a column that will populate another column in another sheet
only IF a criteria is met. Is that possible?
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?
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?
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?
>
>
>
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?
>>
>>
>>
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?
> >>
> >>
> >>
>
>
>
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?
>
>
>
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?
> >
> >
> >
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?
> > >
> > >
> > >
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks