Search and Retrieve rows of data

[ADAMKOCKOTT]

I need to retrieve rows of data from a closed workbook based on a number entered by a user in a cell on the open workbook.

The closed workbook has a number of worksheets therefore the code will need to search each sheet and retrieve matching rows.

Column a has the number to be searched against ( from the user input.

So once the user enters the number the macro needs to seach the closed workbook for any matches in column a and return the entire row. This would have to return each match form the various sheets in the closed workbook.

I have done a few searches but have not found anything thats matches this.

Any help greatly appreciated