I have a table which has 10 columns, a = name, b-e = Address 1,2,3,4, f-j = date of call 1,2,3,4,5. Ideally column f should show the date of the latest call, going down the row to j from newest to oldest.

So one record will have the name of someone, their address and the dates of all calls made to them, there maybe 0 calls, up to 5. However the original data was entered haphazardly so that the dates are not in sequence. The newest date maybe in column h, the oldest in column f etc.

I need to resort the information in these rows so that the newsiest dates are put into f etc.

I can do this on a row by row basis by amending the sort function to read left to right but with over 2,000 records this is not practical. If I highlight multiple rows it sorts them based on the first row, which means only the first row moves and none of the data in the other rows move.

Does anyone have a solution to this?

Thanks