Automatically display sentence.
Sir,
First I want to thank Mr Max who responded me and tried to solve my problem.
I m also very sorry that I have not good knowledge of English. If someone can
understand my problem and can solve this I will be very grateful. I have a
worksheet which have columns in this manner €“
A B C D
Concession Form Received
6 List of C or D Form Received.
7 Form Form No. Date Amount
8 C Form
9 D Form
10 C Form
11 C Form
12 D Form
13 D Form
14 Full Tax
15 C Form
I want to do that a sentence €śList of C Form Received€ť or List of C Form
Due€ť, or List of [ blank ] Form€ť automatically display in a6 in A6. only in
that case when in b8 in front of Form; Form No is Filled.
Otherwise it should be returned blank.
This A6 content sentence should be change with Auto Filter filtering with
specific C or D Form selection. Like when I select blank and C Form it should
be €śList of C Form not Recd€ť, when I selct not blank and C Form it should be
display €śList of C Form Recd.€ť
Regards
RRS
|