software

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 ?

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

peltiertech.com/Excel/Pivots/pivottables.htm

Does that help?

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

XL2002, WinXP-Proquot;thunderbirdsquot; wrote:

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