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