formula help please

[beks101]

hi there,

Alright I hope I can explain this good enough I tend to ramble...

I have created an "accounting workbook" for my father in law to do his
books in. He is a farmer, he is late 50's and has only had access or
ever used a computer for the first time last month. He finally bought
one.

I have created this workbook for him but I have come to a dead end in
something that he has requested be available.

So, I have a seperate worksheet for each month b/c each month he will
enter reciepts, assign them ID #'s enter in the values etc. He has
made up accounts, which are accounts that he has used for the last 30
years while farming so these need to be present.

I have a column for Receipt Number (A); Description (B); Account Number
(C); Account Name(D); GST (E); Expense (F) and Income (G).

What he wants is also to have a page that is going to be a "Year to
Date" page. He would like to have his list of accounts available and
have it keep a running total of EACH ACCOUNT for each month.

a pivot table is not going to work for him b/c of the way he wants to
see things and he doesn't understand them and frankly I don't think I
do either...but all in all its just not an option.

Is there a formula; vlookup, if statement, something that I can put in
that will do this for him?

I am willing to e-mail someone what I have done in case I haven't made
sense here. See these running totals have to be able to add sheets
together and pic from a multitude of account numbers that may be used
in a particular month.

Thanks so much in advance for any help that anyone can give me!

Beks

 

[duane]

it seems to me that you could just manually enter new accounts on the
summary page as they are set up, and use sumif or sumproduct to bring
in the monthly information from all the individual monthly sheets. For
that matter, is there a good reason to have 12 different monthly sheets?
You could just have one sheet for all data entry, and the summary sheet
where you could see the monthly totals of each account.

 

[aidan.heritage]

I'm willing to look at it for you - my email is
(e-mail address removed) in case it doesn't show in this post - worth
noting though that excel will total all sheets in a range in the same
way that it can do cells - so this is possibly the way to go.