Hi I have two spreadsheets, if both are open and the
first one contains 3 columns.

The first column is a reference the second one is an
amount and the third is a date.

The second spreadsheet has a column which the reference
will match. There will only be one match in the list.

Then I will have my row number. The amount and the date
then need entering on the row with the matching ref in
spreadsheet number 2.

I'm not sure if its possible to enter them as I would
like though.

Imagine the row contains data like the following in the
second sheet-

Col A Col B Col C Col D Col E Col F Col G
Ref match 17/01/2005 17/02/2005

So if the first sheet had data like this

Col A Col B Col C
Ref match 16/02/2005 52356

The ref would match so in the same line col f and g would
be filled as below

Col A Col B Col C Col D Col E Col F Col G
Ref match 17/01/2005 17/02/2005 16/02/2005 52356

It has gone there as it is nearer to the date 17/02/2005
than the date in B.

I hope I have explained it well enough for you to be able
to help!

Thanks

Rob