HI Max,

Thanks for that, however I can filter columns due to the fact hat the info is
going out in a report.

This means that I have to return the data in a certain area.

Max wrote:
One thought - since it's all happening in the same sheet, easier just to
apply & use autofilter on col K's dates and read off the filter results in
col B.

Insert a top row for col headers (if necessary)
Then select entire col K, click Data Filter Autofilter.
In the autofilter dropdown in K1,
just select the desired date, and read off col B
Hi,

[quoted text clipped - 30 lines]

I hope someone can help with this as I cant find anything that helps.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200710/1