Hi,
Lets see what I can do. Ill try to be more precise.
1. The base data is contained in separate workbooks not worksheets.
2. I would like to check every row of every worksheet of the base data. Do I
have to copy the macro to these workbooks or will it run from the new
workbook?
3. The base data is contained in the worksheet €˜Sheet 1 in each of the
workbooks.
4. The workbooks are contained in a file structure that looks like this:

a. Payments
i. 2009
1. Jan
2. Feb
ii. 2008
1. Jan
2. Feb

I hope I have provided you with the data needed.
Every piece of help is appreciated.
/m


"joel" wrote:

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