Return to Question

I want to search for a string inserted in "TextBox1" @ Mainwb within a range of data located in Workbook "officerA" Worksheet "DATA"(A2,G2000), and then paste results found into Workbook "Mainwb" .sheet "MAIN SCREEN" .Range (A5,G500)

I want to search for a string inserted in TextBox1 on Mainwb within a range of data located in Workbook officerA Worksheet DATA!(A2,G2000), and then paste results found into Workbook Mainwb.sheet("MAIN SCREEN").Range (A5,G500)

can any one help me in how to improve below code ;

I want to search for a string inserted in "TextBox1" @ Mainwb within a range of data located in Workbook "officerA" Worksheet "DATA"(A2,G2000), and then paste results found into Workbook "Mainwb" .sheet "MAIN SCREEN" .Range (A5,G500)

I am totally new to VBA and wrote this code quoting from many sources ,all your support is appreciated .

Below is the code used to search within same workbook:

Kind regards

I want to search for a string inserted in "TextBox1" @ Mainwb within a range of data located in Workbook "officerA" Worksheet "DATA"(A2,G2000), and then paste results found into Workbook "Mainwb" .sheet "MAIN SCREEN" .Range (A5,G500)

I am totally new to VBA and wrote this code quoting from many sources. I'd like to know how it can be improved.

This is used to search within the same workbook: