PDA

View Full Version : Attn: Spread Sheet Guru.


Dinosaur
11-07-2008, 12:51 AM
I currently use QuatroPro, but could switch to Excel.

I use spread sheets to keep track of my Bank Account, Investments, & Credit Card purchases/Payments.

I keep summary totals at the top of all spread sheets followed by the detailed data in chronological order.

It would be more convenient if the detailed data were in reverse chronological order (latest details first).

Is there some handy programmatic way to accomplish the above? I could enter the current data and then do a copy & paste to move all the details down one row, but this seems so archaic.

tommy
11-07-2008, 02:52 AM
Not familiar with QuatroPro, but in Excel, assuming there is a date column in a proper logical format, just sort on the date column in descending order.

EDIT: Upon rereading your question, and assuming that your data is in reverse chonological order, then your procedure might be:

1-Sort into chron order,
]
2-Add new item(s) to end of spreadsheet,

3-Sort into reverse chron order.

halovivek
11-07-2008, 04:40 AM
HI why you can not try to use Openoffice. It is quite easy than excel.
here you can get openoffice (http://www.openoffice.org)

Dinosaur
11-07-2008, 10:12 AM
Tommy: Thanx. That seems more convenient than cut & paste. If spread sheets were not so handy, I would consider writing a Visual Basic program to handle my financial data.

Halovivek: Open Office might be okay. While not a Grand Guru, I get paid to help computer illiterates. It is best for me to have the more standard products installed on my system for demonstration & teaching purposes.