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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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!A10;Sheet1!A1;"")

HTH
--
AP

"Christy" a écrit dans le message de
...
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!A10;Sheet1!A1;"")

HTH
--
AP

"Christy" a écrit dans le message de
...
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" a écrit dans le message de
...
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!A10;Sheet1!A1;"")

HTH
--
AP

"Christy" a écrit dans le message de
...
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" a écrit dans le message de
...
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!A10;Sheet1!A1;"")

HTH
--
AP

"Christy" a écrit dans le message de
...
I want to have a column that will populate another column in another
sheet
only IF a criteria is met. Is that possible?