"KandK" wrote:
..On my worksheet Row 2 has the dates, 1 column for each date ie GA2 has 04/03/06, GB2 has 05/01/06, GC2 has 05/02/06 etc. Under each date there rows 5-138 any of which may have data but all of which I want to transfer (even if empty). I would also like to transfer the date before and date after if possible.

Aha, so that's how your set-up looks like ..

Here's one play to try ..

A sample construct is available at:
http://www.savefile.com/files/1030392
AutoDisplay Data (Yday, Today, Tmr) in new sheet

Assume source data in sheet: X,
dates in GA2:IV2, data running down in cols below dates

In another sheet: Y,

Put in B1: =TODAY()

In A2:
=IF(ISNA(MATCH($B$1-1,X!$GA$2:$IV$2,0)-1),"",OFFSET(X!$GA$2:$GA$140,,MATCH($B$1-1,X!$GA$2:$IV$2,0)-1))

In B2:
=IF(ISNA(MATCH($B$1,X!$GA$2:$IV$2,0)-1),"",OFFSET(X!$GA$2:$GA$140,,MATCH($B$1,X!$GA$2:$ IV$2,0)-1))

In C2:
=IF(ISNA(MATCH($B$1+1,X!$GA$2:$IV$2,0)-1),"",OFFSET(X!$GA$2:$GA$140,,MATCH($B$1+1,X!$GA$2 :$IV$2,0)-1))

Select A2:C2, fill down to say, C140
(to cover the expected extent)

A2:C140 will return the required results from X

To suppress the display of extraneous zeros in the sheet, click:
Tools Options View tab Uncheck "Zero values" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---