debits

<tbody> <colgroup><col><col span="2"></colgroup><tbody> See below example. D671 = 41,298. 41,298 x %. All % = 100% but when the result hits the debit or credit column, debits do not = credits by a few cents. Any suggestions? JE AMT DEBIT CREDIT </tbody> <strike></strike>...

My goal is to update information in a master report whereby adding information to Excel Tables on other worksheets and have the master report automatically shrink or grow the area required as the data between sections can change? I've looked into several ways to attempt this however in Excel...

I am new to Macros and having a little trouble in identifying a solution I have a row which contains more than 500 items/numbers in postive as well as in negative. these rows match with each other and net to zero just like reconciliation, however, there may be more than 4 negatives which make up...

Hey guys/gals, I'm trying to use VBA to populate an interactive PDF with data used from excel. Please refer to the following link, which describes what I am trying to accomplish: http://forums.adobe.com/thread/2069492 Excel data will consist of accounting values, such as various line items...

I have a file that contains transactions that are broken down into credits and debits. The issue I have is that the debits are not presented as negative numbers. I tried to create a custom column that stated if the transaction type = Debit than multiply it by -1 else keep the original amount...

Hello, I have an accounting worksheet that already has over 1,000 rows, and will continue to gain many more. I was wondering if there is a way to set up cells in the locked row at the top that will always have an up-to-date total of various columns. Ideally, I would have a cell with the total...

Hello, Below is a code I got assistance with that automatically letters groups of cells that net out to 0 and makes them red font color: Dim R As Long, X As Long, StartRow As Long, LastRow As Long, Total As Double Dim Status As String, EText As Variant, FNumbers As Variant On Error GoTo...

Hello, Random question. Is there any way to automatically put in letters for each pair of debit and credits I have in journal entries within excel? For example, I would need A, B, C, D, etc. in a red circle. Thanks, Tony

Hi, I am trying to go through 5000 odd rows to check if a debit and a credit for the same value exist in column E. Basically, what i need is a macro to check the reference number in column B and delete rows that have the matching debit and a credit for that reference number e:g <TABLE...