Query: Combining two sets of data into one

[gstack]

Hi guys,

I've got a question about creating reports in VBA for EXCEL that I was wondering if it could be done. I currently have two sheets with the following forms of information in them:

Sheet 1:

Name, Date , Value
--------------------------------
TAG1, 10-Apr-06, 2.6
TAG2, 11-Apr-06, 1.2
TAG3, 10-Apr-06, 0.3

Sheet 2:

Name, Date, Value
--------------------------------
TAG2, 12-Apr-06, 3.3
TAG4, 15-Apr-06, 5.0
TAG5, 20-Apr-06, 4.7

And I need them to be combined to generate a report in the following format:

Report:

Name, Date1, Date2, Value1, Value2
----------------------------------------------------------------
TAG1, 10-Apr-06,, 2.6,
TAG2, 11-Apr-06, 12-Apr-06, 1.2, 3.3
TAG3, 10-Apr-06,, 0.3,
TAG4,, 15-Apr-06,, 5.0
TAG5,, 20-Apr-06,, 4.7

The problem is that I can't simply combine two sheets together because the names don't exist in the same sheets (i.e. TAG1 is only in sheet1). I tried doing a search statement but it is proving too cumbersome.

Is there an easy solution two combine the two such as arrays, or another method? I'm stuck at the moment :)

Any help would be awesome :bigyello:

[Ecniv]

Don't follow why you cannot just cut n paste into a new sheet...?

[gstack]

The reason is that I'm trying to automate it. It's meant to generate a report from the first two sheets. The information is actually a lot more complex than I provided, I just simplified it as an example.

Edit: Actually, I just figured it out. Just used arrays and a VLOOKUP table in the end. Thanks.