Excel beginner question

Would you be interested in a different solution? You can have what you want in a single sheet instead of 3 separate sheets.

You will probably need these columns
Date
Date reconciled [i.e. date it appeared in the bank statement]
Description
Debit amount
Credit amount
[note that you would normally enter something in either Debit amount or Credit amount but not both]

You could add an extra column in which you name the bank account for that particular transaction.
Account
[note that the entries in this item would be the account name exactly as used in the columns headers shown below]

So then you write formulas in your Balance columns, of which there is one for every account
Account1
Account2
[I have used SB&R and Cbank in the example below]

So its set of column headers would look like this

and in each entry under the Account1, Account2 column headers you write [row 4 used in this example - the same formula is dragged to every line]
=IF($F4=O$1,O3+$N4-$M4,O3)
which is, in words,

If the Account name for this entry matches my column header

[if Yes] I subtract any entry in the Amount debit column and add anything in the Amount credit column to the balance I had in the previous row
[if No] I repeat the same balance that I had in the previous row

If you are interested in the idea then I can talk you through the whole thing.

Denis

And I simplified my explanation - I have 29 account columns [not all in use].

I've been using this scheme for over twenty years and as I switch bank accounts I just leave the old column in place and use one of the many spare columns I had ready.
- The spare columns are fully written up with their formulas and are just narrowed to width 1 so they are not a distraction.
- Old bank account columns are not deleted. They are also just narrowed to width 1 so they are not a distraction.
- The width 1 columns just appear as a grey blur between active columns so they do not get in the way at all. You can see some on both sides of the F column in my posted picture [many of those particular ones used to be additional 'Description' notes but I found I didn't really need them and they just took up space].

About "look very messy"
You can see the Auto-Filter symbols on the columns. If I want to focus on one particular account I use that [or I right-click on an entry in that column and select Filter, Filter by cell's value]

Denis.

"I really only know Sum=() and that's all...."

I'd insert all the forumulas for you. In fact, here is a copy for you to play with [and if you keep the zip file you'd retain a pristine copy to use later on]
Tsw88 version.zip

Notes about the example entries in the sample file & about general use

1 I have put in sample entries so you can see that it calculates correctly.

2 The file currently shows 27 accounts. Just re-width columns you will not want to use / see [select a column, right-click, column width, 1, OK]. During normal use, setting them to 1 unit of column width is better than deleting them or hiding them because doing that can make Excel automatically & unhelpfully adjust formulas depending where the deletion/hiding is done.

3 My best screen shows up to the column for Account14 without any sideways scrolling but I normally only have up to 8 active accounts which also displays well on my smaller screens so I can avoid any sideways scrolling at all.

4 I tend to colour the nyd cells & any estimated entries in blue so I do not forget their status. So, for example, if an entry was definite but its effective date was in some doubt I'd make the other cells black but make the date cell blue.

5 Never delete an entry. Instead, copy the nyd cells you can see in blue on top of the entry to want to 'delete'. So you might, just for example, copy cells A88-N88 into cells A38-N38 if you wanted to 'delete' the latter.



6 When you need more lines, select the bottom set of, say, 10 rows then copy the entire rows not just individual cells then put your cursor in the first blank cell in column A then Paste. I always add more cells whenever I start to approach the bottom so that I always have at least 10 nyd rows to copy from [doing them row by row gets annoying].

7 If you want to re-sort the entries, always make sure you select the whole set of columns all the way to the Account27 column [the AO column]. Selecting less than the whole area also makes Excel unhelpfully change formulas. After selecting the whole lot, you can use the item in the standard Ribbon - Sort & filter, Custom sort to choose what you want to sort by.

8 Only the cells under the Account1, ..., Account27 headers contain formulas. If you want to examine the formula in a cell, you can double-click on that cell and Excel will highlight the other cells to which it refers. I can explain more about the forumulas when you want.


Denis

And I should have reset Excel's zoom control back to 100% before saving & posting that file. The zoom control is in the bottom right of the Excel window.

Denis

Mistyping in previous posts -

Where I wrote that setting an unused column to width
1
would stop it being a distraction, I should have written
.1

Denis

Tsw88,

How are you getting on?

I assumed that, if you had decided to proceed with it, you would want me to talk you through the equation =IF($F4=O$1,O3+$N4-$M4,O3) that is used all over the spreadsheet.

Denis