Can you be more precise.

1) Are you talking about multiple workbooks or worksheets. filename referes
to the workbook
2) Do you want to check every row in every worksheet of the workbook where
the macro is located.
3) Be specific about worksheet names to include or not include.

Macros can search through folder on your compter, go through all worksheets,
creatte new workbooks, create new worksheets.

"m" wrote:

Hi,
I am trying to compile data from several worksheets.
My base data are sheets sent to payroll for payment of different costs.
These are sent out every month so going through all sheets and filter and
then copy is not really an option.
Is there a macro that looks up whether or not a value is present in a row
and returns the whole row in a new spreadsheet? The value I am looking for is
€œIA3€�.
The basic layout of the tables are as follows:
Reference €“ Payment type €“ Payment amount
Ideally it would copy the whole row if the value €œIA3€� is present to a new
spreadsheet and perhaps add the filename where it found it.
Thanks,
/m