merging or cancantinating worksheets

[J.B. Bobbitt]

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>

 

[Dave Peterson]

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