Conditions & Populating

C

Christy

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

Guest

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.
 
A

Ardus Petus

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
 
C

Christy

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.
 
G

Guest

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.
 
C

Christy

MUCHAS GRACIAS! :)

AndyB said:
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.
Click to expand...
 
C

Christy

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
 
A

Ardus Petus

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
 
Top