title: Code for command button to search text data in two worksheets, and copy/paste to the third one
body: <p>I have agreed to help out with some small project at my work that requires a VBA knowledge. I have worked previously with SQL and I thought the VBA is quite similar but I have stuck. </p>
  
  <p>I need a code for the command button to search for the string/text data specified in text box. It will search for data in cells in column B in two worksheets and copy and paste entire rows where the required data was found to the third worksheet.</p>
  
  <p>The searched data can be recorded few times in each worksheet so it will have to loop and search through whole two worksheets and copy and paste all information's related to the search data.</p>
  
  <p>The headers in worksheets one and two (where data are stored) and worksheet three (into where data will be pasted) are the same. The ranges for two worksheets where data are stored are entire worksheets apart from A1:J1 (the headers) and for the third worksheet where the data going to be pasted the range is A11:J1500. </p>