Hi,

I have one large sheet call a.xls which has data going down the column. e.g

Hr target
8 10
9 12
11 9
12 15
14 20

Another worksheet on seperate workbook - calls b.xls, basic on matched
data - hour, to transpose on to. The layout on the b.xls look like this
between hr 8 - 9 9 - 10 10 - 11 11 - 12 12 - 13
13 - 14
Target 10 12 15
20

The 10, 12, 15 and 20 on the Target of b.xls is from a.xls

If there is no matching data between a.xls and b.xls on the hour, just leave
the field blank on b.xls

How can I do this please ?

Many thanks,

Rach