I am sorry for that.

Here is the explanation.

Let say the textbox value is = Al Dar Hospital (Quba) - 2015 the all the rows which is having this values will be extracted from worksheet (Data) to the worksheet (Statement) (See the attachment in my first post). Then see those batch no. in worksheet (Resubmission Adjustment) in column B and same worksheet column D if the values are Resubmission Adjustment copy only those row from worksheet (Resubmission Adjustment) to worksheet (statement).

I hope this time I have explained correctly to make you understand. kindly see my first post with the attachment showing what is the output result in worksheet (Statement).

then look for the sale value in