merging or cancantinating worksheets

Hi all;

I need help merging worksheets, as follows:

I've got two workseets: Sheet1, Sheet2
Sheet1 ColA are dates; ColB through ColD are filed with numerical data
Sheet2 ColA are dates; ColB through COlD are filed with numerical data
The date values in Sheet1 and Sheet2 may or may not be the same; some
entries will be different
The data values in ColB through COlD in Sheet1 are different that the data
in COlB though ColD in Sheet2

I want to end up with ONE worksheet with ONE date column and 6 data columns,
with the data columns having no entries where necessary.

I believe this is called "cancantination" (?). In SAS, it went:

proc merge;
by date;

Is there an Excel function or easy way to this in VBA?

Once again, thanks a heap.

-jbb


--
J.B.Bobbitt

<thud>

I'd create a new worksheet.
Copy both date columns to column A of that new worksheet
(but only one header row)

Then I'd use data|filter|advanced filter to get a list of unique dates
(eliminating duplicates)
Debra Dalgleish has a nice instruction page at:
http://www.contextures.com/xladvfilter01.html#FilterUR

Then use a bunch of =vlookup()'s to retrieve the values from the first sheet and
the second sheet.

Again, Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html



"J.B. Bobbitt" wrote:
>
> Hi all;
>
> I need help merging worksheets, as follows:
>
> I've got two workseets: Sheet1, Sheet2
> Sheet1 ColA are dates; ColB through ColD are filed with numerical data
> Sheet2 ColA are dates; ColB through COlD are filed with numerical data
> The date values in Sheet1 and Sheet2 may or may not be the same; some
> entries will be different
> The data values in ColB through COlD in Sheet1 are different that the data
> in COlB though ColD in Sheet2
>
> I want to end up with ONE worksheet with ONE date column and 6 data columns,
> with the data columns having no entries where necessary.
>
> I believe this is called "cancantination" (?). In SAS, it went:
>
> proc merge;
> by date;
>
> Is there an Excel function or easy way to this in VBA?
>
> Once again, thanks a heap.
>
> -jbb
>
> --
> J.B.Bobbitt

--

Dave Peterson