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