| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A reference problem - I THINK? | Excel Discussion (Misc queries) | |||
| Reference problem | Excel Discussion (Misc queries) | |||
| problem with reference | Excel Programming | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
| Need help with this reference problem | Excel Programming | |||
Hybrid Mode
