I am trying to make a book keeping record in excel, I have eveything working
but one thing. This is how I have it mapped out, my sheets are named page 1
of jan, page 2 of jan and so on to dec. On page 1 G, H, and I columns I put
the date how I paid and check # in column J is where I put a acct# and K the
amount. On page 2 column F I have a list for 1 to 31 of accts. and in G the
name of the accts in column H is the total for the month. What I want it to
do is when I put in a acct. # on page 1 and a amount I want it to go to page
2 in the totals column. For example if I have entered 3 in J5 and $100.00 in
K5 and 3 in J6 and $200.00 in K6, I want it to total in page 2 In my H column
for that account.
I don't know if there is a formula for that or not. Thanks a lot if you can
help me.