Searching data and displaying using a form.

Hello Everyone

Not been on here in a while.

I have a sheet with a large amount of data. I want to be able to use a user form to search through the sheet for specific data i.e. somewhere in the sheet 12345 is written (only once), whatever the user searches for, if the data is found, then I need the first five columns (40cells deep) bellow the point where that data is to be copied and pasted onto a new sheet, that sheet must then be displayed.

Example: If 12345 was in A10 then Cells A10:E50 would be cpoied and pasted onto a new sheet.

Does that Make sense.

Any help would be sooo good as this is pretty tricky.

Thanks

Perhaps this will start you off:

Please Login or Register  to view this content.

thanks.

I have created a command button on the userform and put this code to it but when it is clicked nothing seems to happen? Any ideas?

Also the code must search for whatever the user types into the text box, not just 12345.

Hence my comment:

Please Login or Register  to view this content.

Dont worry, i have used this now

Please Login or Register  to view this content.

However I need to stop if from searching and pasting if the text box is left empty and the button clicked. This bit of code doesnt seem to do it

Please Login or Register  to view this content.

Where have I gone wrong?