I have 3 workbooks open and each has dates in column A with other
information in the other columns. The problem is each date is used several
times. I would like to be able to combine the 3 files and have the first
use of each date line up across. Right now, I have all 3 open and arranged
vertically. I am aligning the 2nd with the 3rd file first, th-n the first
with the 2nd. For instance, A918 in the 2nd is 2004-08-19, I then look over
in the 3rd and see that 2004-08-09 there is in A924, then I go back to the
2nd, highlight the row with A918 and insert 5 rows (one less than the
difference) - which makes the first instance of 2004-08-19 line up between
the 2nd and 3rd files. I'm sure this can be handled with a Macro, but I
don't know how to set it up. There are over 7000 columns, so it would
REALLY help! Thanks for any help!

LM

2004-08-19 is this stored as a date serial or is it stored as a text
string. If you formatted the cell as general does it appear as: 38218 or as
2004-08-19 and is this true for all the dates in all the workbooks.

Are the sheets the first sheet in each of the workbooks?

Assume the dates are sorted by date in ascending order?

multiple rows with the same dates would stay contiguous?

--
Regards,
Tom Ogilvy




"Larry M" wrote:

I have 3 workbooks open and each has dates in column A with other
information in the other columns. The problem is each date is used several
times. I would like to be able to combine the 3 files and have the first
use of each date line up across. Right now, I have all 3 open and arranged
vertically. I am aligning the 2nd with the 3rd file first, th-n the first
with the 2nd. For instance, A918 in the 2nd is 2004-08-19, I then look over
in the 3rd and see that 2004-08-09 there is in A924, then I go back to the
2nd, highlight the row with A918 and insert 5 rows (one less than the
difference) - which makes the first instance of 2004-08-19 line up between
the 2nd and 3rd files. I'm sure this can be handled with a Macro, but I
don't know how to set it up. There are over 7000 columns, so it would
REALLY help! Thanks for any help!

LM

2004-08-19 is stored as Number/General (this info. was exported from an
Oracle database into excel for me and was shown as 20040819 - I custom
formatted it to add the "-"). All 3 workbooks are the same format.

Each sheet is the first and only one in each workbook.

The "dates" are sorted in ascending order.

Multiple rows with the same dates are contiguous.

Thanks for trying to help!
"Tom Ogilvy" wrote in message
...
2004-08-19 is this stored as a date serial or is it stored as a text
string. If you formatted the cell as general does it appear as: 38218 or
as
2004-08-19 and is this true for all the dates in all the workbooks.

Are the sheets the first sheet in each of the workbooks?

Assume the dates are sorted by date in ascending order?

multiple rows with the same dates would stay contiguous?

--
Regards,
Tom Ogilvy




"Larry M" wrote:

I have 3 workbooks open and each has dates in column A with other
information in the other columns. The problem is each date is used
several
times. I would like to be able to combine the 3 files and have the
first
use of each date line up across. Right now, I have all 3 open and
arranged
vertically. I am aligning the 2nd with the 3rd file first, th-n the first
with the 2nd. For instance, A918 in the 2nd is 2004-08-19, I then look
over
in the 3rd and see that 2004-08-09 there is in A924, then I go back to
the
2nd, highlight the row with A918 and insert 5 rows (one less than the
difference) - which makes the first instance of 2004-08-19 line up
between
the 2nd and 3rd files. I'm sure this can be handled with a Macro, but I
don't know how to set it up. There are over 7000 columns, so it would
REALLY help! Thanks for any help!

LM