Hai Keeb,

I think I haven't explained properly this is totally different output.

What I need here is look for textbox values in both worksheets and copy data into statements from both worksheets but in below conditions.

1. From Worksheet data copy the entire row where the text value match.
2. From Worksheet “Resubmission Adjustment” look for the textbox value and copy only those row where the batch no. In column B which is present in Worksheets “Data” in column G and Worksheet “Resubmission Adjustment” in column D cell value is Resubmission Adjustment.

I hope you got me explanation properly.