"maggiemay" wrote:

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?

Hi Maggiemay,
Have you found any information yet regarding your post? I need to know the
exact same thing! Thanks :-)