tonylpcs@yahoo.co.uk
Active Member
- Joined
- Dec 19, 2007
- Messages
- 379
Hi Everyone,
Ok Got one More i hope this is it so thanks to everyone for your help!
i have three colums K, M, & O, and i need the data from another cell to be input into one of them depending on the situation,
so first of all i only want the data to apear if sheet2 R1 = "NO" otherwise i want a blank line, however if sheet2 R1 does ="No" then i want the following to happen
in O1 i want if sheet2 Q1 = "no" then input the data from I1, if not blank
in M1 i want if sheet2 Q1 = "yes" and sheet2 J = "Renewal / Other" then input the data from I1, if not blank
and in K1 i want if sheet2 Q1 = "yes" and sheet2 J = "New Business" then input the data from I1, if not blank
i think i will need 3 different formulars but if you can let me have what i need for
O1
M1
K1
this would help me a great deal thank you
Tony
Ok Got one More i hope this is it so thanks to everyone for your help!
i have three colums K, M, & O, and i need the data from another cell to be input into one of them depending on the situation,
so first of all i only want the data to apear if sheet2 R1 = "NO" otherwise i want a blank line, however if sheet2 R1 does ="No" then i want the following to happen
in O1 i want if sheet2 Q1 = "no" then input the data from I1, if not blank
in M1 i want if sheet2 Q1 = "yes" and sheet2 J = "Renewal / Other" then input the data from I1, if not blank
and in K1 i want if sheet2 Q1 = "yes" and sheet2 J = "New Business" then input the data from I1, if not blank
i think i will need 3 different formulars but if you can let me have what i need for
O1
M1
K1
this would help me a great deal thank you
Tony