Expert: Victor Lan - 11/7/2009

Question
Dear Victor,

I'm making a financial spreadsheet.  I need to be able to sort 5 columns and up to 20 rows (can be less) of data automatically and alphabetically, putting the empty rows last, using formulas.  The columns and rows would be as follows:

Creditor   Interest   Total     Months   Date
we         $2722.84   $7722.84  64       March-15

and up to 19 more rows of data.

I need it automatic so that when stuff changes, these rows sort automatically and without using macros.

I hope you can help, I can't figure it out and must get an answer from somewhere.

Thank You,

Greg

Answer
Hi Greg,

In order to sort it automatically, you will need to use VBA macro to capture worksheet events. However, it may not be efficient if the worksheet contains large amount of data.

Let me know if you need a VBA solution and I'll assist.
Thanks.

Regards,
Victor LAN