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