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 ?