1. pick an un-used column and enter:
=ROW() and copy down

2. copy the column and paste/special/values back onto the column

3. sort the worksheet by the new column DESCENDING

this will reverse all the rows.
--
Gary''s Student - gsnu200859


"CT EA" wrote:

I have several columns in a single spreadsheet that have a date (12/01/01 and
ascend to 12/31/09. There are also several rows of corresponding data
underneath each date. Is there a way to reverse this information using a
formula rather than cutting/pasting/moving?

Thanks in advance