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" 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?
|