I prepared a worksheet with years and names. This worksheet showed names,
dates and other data (total five columns) with the names (column 2) in
alphabetical order A to Z.
I copied this to a second worksheet which showed all the same data but in
year order (column 1) 1999 to 2010.
Can I now insert a row of data in the first worksheet and get it to
automatically be inserted in the correct position in the second worksheet?