Statement of Account

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lou - 18 Dec 2005 01:03 GMT

I need to reconcile some data for a hockey team and am in need of a "
Statement of Account " spreadsheet. I don't know how to draft my own
so does anyone have a template? I tried to use the one on the Microsoft
web site the problem is I can't seem to be able to sort the Description
column alphabetically??? help

Reply to this Message

Gord Dibben - 18 Dec 2005 01:26 GMT

Lou

You can't sort because there are merged cells in the selection.

Select A11

Format>Cells>Alignment. Uncheck "Merge Cells"

Doesn't harm the worksheet and you can use "Center across selection" if you
want to re-format the look of the "brought forward" in row 11

Gord Dibben Excel MVP

>I need to reconcile some data for a hockey team and am in need of a "
>Statement of Account " spreadsheet. I don't know how to draft my own
>so does anyone have a template? I tried to use the one on the Microsoft
>web site the problem is I can't seem to be able to sort the Description
>column alphabetically??? help

Reply to this Message

Lou - 18 Dec 2005 02:25 GMT

Thanks Gord,

Merged cells doesn't seem to be checked. The second problem with this
template is that it seems to have dropped the ability to add my account
balance column. I assume it is likely because I have used the delete
button along the way. Believe it or not I have spent all day and night
now trying to what should be simply for most people. Resorted to try
and use word to recap my figures, nightmare

Reply to this Message

Lou - 18 Dec 2005 02:29 GMT

Sorry Gord, you are right I uncheck merged cells but I am still unsure
how to sort alphabetically, it soesn't seem to be an option under
sort. The second problem is the template seems to have dropped the
ability to add the balance column??

Reply to this Message

Gord Dibben - 18 Dec 2005 05:08 GMT

I will preface this with the advice that you start doing things on a copy of
the worksheet.

Hold down the CTRL key and drag the worksheet to the right. A copy will be
created.

Alphabetically sorted means sorted in Ascending order.

As in a to z

In your case, sort on Column B(Description) in Ascending order.

NOTE: very important that you select all 5 columns A through E starting at
row 12.

Do not sort above that.

If you look in the cells in column E(account balance) there should be a
formula in each one that keeps track of the balance as you enter debits and
credits.

The one in E12 is this...............

=IF(ISERROR(IF(OR(C12,D12),((E11)+C12-D12),)),"",IF(OR(C12,D12),((E11)+C12-D12),))

If the others are gone, just enter and drag/copy down the column.

OR...........re-download the Template and start over.

Gord

>Sorry Gord, you are right I uncheck merged cells but I am still unsure
>how to sort alphabetically, it soesn't seem to be an option under
>sort. The second problem is the template seems to have dropped the
>ability to add the balance column??

Reply to this Message