Sir,
I have have a worksheet which have columns in this manner €“


A B C D
Concession Form Received

6 "List of C / D Form Received."
7 Form Form No. Date Amount
8 C Form
9 D Form
10 C Form
11 C Form
12 D Form

I want to do that The sentence €œList of C Form Received€� or List of D Form
Received" List of Due D form€�, List of Due C Form", automatically display in
A6. only in that case when in b column in front of Form; Form No is Filled,
otherwise it should be returned blank after filtering with specific C or D
Form selection.

I hope you one of MVP will solve my problem.

Thanks & Regards

Rao Ratan Singh