Hi,

I have three datasets in different excel workbooks which I need to
consolidate into one summary sheet but the three data block from each
sheet needs to be aligned by a common field in the three workbooks:
Column A which has dates for each block.

The set up of the different workbooks is as follows:

In each of the three workbooks, Column A has dates and row 1 as the name
of the indicators.

In the first workbook, the data starts in row 4 and column G and ends in
row 8632 (but this changes from week to week) and column AX.

In the second workbook, the data starts in row 2 and column B and ends
in row 5411 (changes week to week) and column AA.

In the third workbook, the data starts in row 2 and column B and ends in
row 6044 (changes week to week) and column E.

Is there a quick way to consolidate all the data by the date field into
a summary sheet from the three worksheets/books?

For example the summary sheet could look like this:

Column A = All possible dates contained in column A of the three files.
Columns G to AX would have data from the firstwook book aligned by the
date field. Columns AY to BX would have the data from the second
workbook aligned by date and BY to CB could contain the data from the
third file.

Would using vlookup or some kind of match function work to achieve this?
I'm seeking a VBA solution as in the past I've found having lots
functions in worksheets really slows down working with them.

Hope someone can help.

Thanks,

Lucas


*** Sent via Developersdex http://www.developersdex.com ***