R
Robert Gestell
I have a question regarding the matching of data:
I have two worksheets, each with two columns of data:
Worksheet 1's columns are:
(Date)--------(Exchange Rate)
Worksheet 2's columns are:
(Date)--------(Interest Rate)
For every given date, I would like to match every value of (Exchange Rate)
with a value of (Interest Rate). That is, I only want one worksheet in the
following form:
(Date)--------(Exchange Rate)--------(Interest Rate)
Unfortunately, directly copying and pasting the data "at the same height" is
not possible, because the start and end dates differ.
Can this be done with Microsoft Excel without having to create a macro?
Thank you in advance. Regards,
Robert
I have two worksheets, each with two columns of data:
Worksheet 1's columns are:
(Date)--------(Exchange Rate)
Worksheet 2's columns are:
(Date)--------(Interest Rate)
For every given date, I would like to match every value of (Exchange Rate)
with a value of (Interest Rate). That is, I only want one worksheet in the
following form:
(Date)--------(Exchange Rate)--------(Interest Rate)
Unfortunately, directly copying and pasting the data "at the same height" is
not possible, because the start and end dates differ.
Can this be done with Microsoft Excel without having to create a macro?
Thank you in advance. Regards,
Robert