can anyone help me please?
Rob,
Just to clarify your question:
Do you want to match the date in your first sheet with the two dates ( in
Cols B and E)i n the second sheet and then place the data from sheet one with
the data which has the closest match?
So data would go into Cols C/D if the date was closest to that in col B or
F/G if closest to the date in col E.
In your example if the date in sheet one was 19/01/2005 the resuilts would
be in cols C/D - correct?
If so, calculate Date differences (Sheet1Date - sheet2Date1) and
(Sheet1Date-Sheet2Date2) and find smallest. Use these differences to detrmine
where to put your data.
HTH
"Rob" wrote:
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
|