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