Sorting Rows - Data and Dates

[jdmc45]

Hi everybody,

I have a spreadsheet with 61 columns of cash flows and 61 columns of dates, corresponding to these cash flows. Most of these entries will be empty as usually there are only a few cash flows per row.

Data looks like:

A        B        C               BI             BJ              BK        ...      DR
CF1     CF2    CF3     ...    CF61         Date1          Date2           Date 61
900     -400   -200                        12/31/2010   01/02/2011
-1000   125                                  01/02/2009   02/05/2008
400                                             01/04/2008

I want to sort the cash flows and the corresponding dates according to dates from oldest to newest, ie. in chronological order. So for the second row of the data above, the as the cash flow(and date in BK) is earlier than the date in BJ, the row should read

CF1         CF2             ...       Date1                Date2
125       -1000           ...       02/05/2008        01/02/2009

Hopefully someone can help me out soon!

Thanks!

 

[jdmc45]

any help anyone?