I have Created a main Userform for data to be enter into a main sheet called "MasterData" which works very well. Now I am trying to create a second userform that will search through this data for a specific job number that is enter into one of the text boxs and then create a new sheet to view the data in. I have a CalendarPicker on this user form with one text box for the job number.
On the second user form I am trying to use a textbox that would filter the data searching for "Job Number" that they will scan in from travelre. I have the userform creating a new worksheet for this data but can't get it to pull in any data. I am very new at this so I have pieces this together from searching on the net.
So for the text box being a filter I am not sure what I should put here and do I also include the range of the data I want they will be sent to the new sheet that will be created. Here is my code for everything: