I think a Pivot Table might be what you're looking for...
Try this website for more details:

http://peltiertech.com/Excel/Pivots/pivottables.htm

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"thunderbirds" wrote:

I have a large list of information (sheet1)showing lorry movements in several
columns as follows:
Lorry Date Dep From To Arr
1 27/12 06:00 Leeds Aberdeen 18:00
2 27/12 06:15 Bristol Glasgow 18:15
This list is amended each week and the number of items in the list can
increase/decrease. I want sheet2 to just show entries for lorry 1 only, so
if the list is amended or an item added to the list it will be replecated on
sheet2 without having to re key. I know I could use a filter on sheet1, but
I want the info to appear automatically on a different sheet. Any ideas ?