Search and then copy data from one sheet to another.

[danbates]

Hi,

I have a workbook with 2 sheets. 1 with the data SCANNING and the other SEARCH.

The SEARCH sheet has a TextBox1 and CommandButton1 on it.

I would like it to search the SCANNING sheet and if an entry or entries are found it then copies the data from the SCANNING sheet to the SEARCH sheet.

It's column D I would like to search and then copy the data from that row (A:K) to the same columns on the search sheet.

There will be multiple entries per search so I would like all the found entries to be copied down on the SEARCH sheet from row 9.

Any help would be appreciated.

Thanks

Dan