Auto-populating a worksheet

[Bear]

I'm working with the general audit plan worksheet template, which
comes with three different worksheets - Plan, Execution and Audit
Recommendations.

Cells in the C column of the Plan worksheet auto-populate their data
in corresponding cells in the Execution worksheet.

Column D in the Plan worksheet is a Yes-No cell.

Here's what I'd like to be able to do.

1. Include a "N/A" in the D cells, so that the options are Yes, No & N/
A. How do I do that?

2. Make it so that if the D cell option selected is either Yes or N/A,
the data in the adjacent C cell does not auto-populate in the
Execution worksheet. How do I do that?

I'd greatly appreciate any assistance.

Many thanks.

 

[Shane Devenshire]

Hi,

1. You didn't tell us how the answers in column D are limited. a. Tell the
users there are three possible answers Yes, No, or NA that they can put in
column D. b. Change the Data, Validiation options so that NA is one of the
choices.

2. On the other sheet, you did not show us the formulas that pick of the
data, but lets suppose it is something like
=Sheet1!C1
Change this to

=IF(OR(Sheet1!D1="Yes",Sheet1!D1="NA"),"",Sheet1!C1)

If this helps, please click the Yes button

Cheers,
Shane Devenshire

 

[Bear]

Hi,

1. You didn't tell us how the answers in column D are limited.  a.  Tell the
users there are three possible answers Yes, No, or NA that they can put in
column D. b. Change the Data, Validiation options so that NA is one of the
choices.

2. On the other sheet, you did not show us the formulas that pick of the
data, but lets suppose it is something like
=Sheet1!C1
Change this to

=IF(OR(Sheet1!D1="Yes",Sheet1!D1="NA"),"",Sheet1!C1)

If this helps, please click the Yes button

Cheers,
Shane Devenshire












- Show quoted text -

Hi Shane,

Thanks for the quick response. Your advice answered my question
regarding how to add NA to the cells in that column. Now I'll have to
experiment with your recommendation on how limit the reproduction of
the recommendation in the Execution worksheet to only those questions
in which NO is the selected answer to the question. I have to admit
that I'm a novice at this and will probably have to ask for your help
again. Thanks again and have a real happy Thanksgiving.

 

[Bear]

Hi Shane,

Thanks for the quick response.  Your advice answered my question
regarding how to add NA to the cells in that column. Now I'll have to
experiment with your recommendation on how to limit the reproduction of
the recommendation in the Execution worksheet to only those questions
in which NO is the selected answer to the question. I have to admit
that I'm a novice at this and will probably have to ask for your help
again. Thanks again and have a real happy Thanksgiving.- Hide quoted text-

- Show quoted text -

Hi Shane,

It worked! Thank you very much. One more question: When Yes or N/A is
chosen in the Plan worksheet (which prevents ther recommendation from
populating the Execution worksheet (which is what I want), the word
"FALSE" displays in the cell that the recommendation would otherwise
be in. How can I change the word "FALSE" to something else (and make
it the default word)?

Again....many thanks for you help.

Bill