reference problem
 

I have had some else working on a check register spreadsheet and it is
almost
finished but there is still a problem with where the data is posted to.
Can
someone take a look at this spreadsheet and help me with it?

You can download it
hehttps://www.sharemation.com/zeusdo/c...ls?uniq=skoquz


when writing a check, the data in the category field and the amounts
are
not getting posted in the register correctly and the balances are not
adding
up correctly.


--
zeusdo
------------------------------------------------------------------------
zeusdo's Profile: http://www.excelforum.com/member.php...o&userid=31730
View this thread: http://www.excelforum.com/showthread...hreadid=514438

reference problem
 

Visibly, your code sends the data from sheet "Check" into wrong columns of
sheet "Result"

This is the code to be corrected:

' Post check amount to register as a withdrawal.
anchor_cell.Offset(0, 5).Value = Range("Amount").Value

' Post bank balance to register as a formula.
anchor_cell.Offset(0, 7).FormulaR1C1 = anchor_cell.Offset(-1,
7).FormulaR1C1


HTH

--
AP

"zeusdo" a écrit dans
le message de ...

I have had some else working on a check register spreadsheet and it is
almost
finished but there is still a problem with where the data is posted to.
Can
someone take a look at this spreadsheet and help me with it?

You can download it
hehttps://www.sharemation.com/zeusdo/c...ls?uniq=skoquz


when writing a check, the data in the category field and the amounts
are
not getting posted in the register correctly and the balances are not
adding
up correctly.


--
zeusdo
------------------------------------------------------------------------
zeusdo's Profile:
http://www.excelforum.com/member.php...o&userid=31730
View this thread: http://www.excelforum.com/showthread...hreadid=514438

reference problem
 

Thank you for your reply but I have never worked with the code, Can yo
tell me how to make the changes

--
zeusd
-----------------------------------------------------------------------
zeusdo's Profile: http://www.excelforum.com/member.php...fo&userid=3173
View this thread: http://www.excelforum.com/showthread.php?threadid=51443

reference problem
 

I figured out how to change the info you said but I found another
problem.

It does not update the balance when I enter a new check.


--
zeusdo
------------------------------------------------------------------------
zeusdo's Profile: http://www.excelforum.com/member.php...o&userid=31730
View this thread: http://www.excelforum.com/showthread...hreadid=514438

reference problem
 

Before you enter new checks, you have to suppress the 2 or 3 faulty John
Doe's checks.
See corrected version: http://cjoint.com/?cvkUBnWGbT

Cheers,

--
AP


"zeusdo" a écrit dans
le message de ...

I figured out how to change the info you said but I found another
problem.

It does not update the balance when I enter a new check.


--
zeusdo
------------------------------------------------------------------------
zeusdo's Profile:
http://www.excelforum.com/member.php...o&userid=31730
View this thread: http://www.excelforum.com/showthread...hreadid=514438