debit

<tbody> User ID Amounts Posting Date 11 $500 2017.07.24 11 -$150 2019.04.05 11 -$200 2019.05.10 11 $200 2019.06.24 11 -$350 2019.06.25 11 $600 2019.09.03 11 -$100 2019.09.07 11 -$200 2019.10.03 </tbody> I there a way in which I could automatically...

<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>...

Hello I am trying to cut down on the amount of time spent on a very manual task which is performed on a monthly basis using Excel. The account is a receivables type account and it starts off by exporting the general ledger in an excel format for the month in review. Then two columns are...

Hi to all of you, kindly require to provide me support for a VBA code so that, to run through col. “K” and where exist numbers, should offset (move) them one cell back, in order that, numbers from col “J” to be placed in col. “I” and numbers from col. “K” to be placed in col. “J”. I present...

Hi guys. I'm creating a bank statement format on excel; but need help in the balance column. I want the amount to be displayed only if the value is entered in debit credit columns (either 1 column). A B C...

Hi all I have file data.xlsm with 03 sheets("result","balance01","balance02") Now I want macro VBA to check value each account number in row i sheet(balance01).column(B,C) with the same account number in row j sheets(balance02).column(F,G) If the same account but value(Bi) <> value (Fj) or...

I have 1700 hundred record some are debit and some are credit I need to move credit value in debit column with negative sign as value

Hello, would you please improve the macro? The issue arises when I have numbers in both columns (A and B) in Debit and Credit. For example In Debit 1,000 and in Credit 1,200. So, in column A should be (200) after running a Macro. Sub MoveCredits_v3() With Range("A2:A" & Range("B" &...

Hi Expert's Ihave an issues e.g column “A” I have same value of debit and credit, I need tomatch this debit and credit value how it possible? A 1222 1222 -1222 -1222 Thank in advance

Greetings everyone, After scouring the internet for days now, and unable to find a solution to fit my needs, I present this question to you wise souls. If a solution already exists on this forum, then please accept my sincerest apologies for reposting, as I was unable to find it using the...

Hi all, kindly advice me for a VBA code so that to run through col. “E” and where find the codes which are in below extract, should transfer them from “Credit” side col.”J” to “Debit” col. “I”. Please see below original data and expected result. Thanking you in advance Original data <!--[if...

Hi I have a file which has 2 sheets. One is called FORM and another called Details. in the Details sheet, in the second cell, I have the following formula: =IF(FORM!A2<>0,FORM!A2,IF(FORM!B2<>0,-FORM!B2,0)) Everything is working fine. I created these tables by myself in a new file but I have...

When I "Paste as Value". I would like to have the text automatically replace itself to something new in the same cell. IE: "POS DEBIT - MCDONALDS" --> *Paste into cell* --> "MCDONALDS". I cannot seem to find a function to fit this once I paste it. Is there a VBA script to help? I will...

Hello, I am hoping someone can assist me with figuring out a formula that can add a flag in a "NoMatch" type column as displayed below based on a similar set of data. The purpose is to identify where a particular ID has a debit without a matching credit. I assume the fact that the ID can be...

There are 2 columns Debit and Credit both with positive sign. I need to put numbers from Credit into Debit Column with sign "minus". <colgroup><col><col></colgroup><tbody> Debit Credit 1250000 140 140 140 140 </tbody>

Hi, i have a userform where the input fields are copied to a worksheet. Supposing i have 5 columns, a-serial number, b-debit code, c-debit amount, d-credit code, e-credit amount. there are cases where the number of debit amount does not equal to the credit. Example: serial # 2018-001 has 1...

Hello! I currently have the following macro that highlights "offsets" in my spreadsheet. Sub Offsets() Dim Cell As Variant For Each Cell In Range("B2:B2500") Dim rng As Range Set rng = Range(Cell, Cell.Offset(1, 0)) If Application.WorksheetFunction.CountIf(Range("B2:B2500"), Cell) > 1...

Hello, I have an excel file: - For the 1st 100 worksheets called "1","2","3","4","5"..."100" are the debit notes to different companies, suppose the print area is A1:G77, default print setting is 1 page - For the 101st worksheet called "Supporting" which is the page 2 of those debit notes &...

Below is the Raw bank statement <tbody> Book Date Transaction Type Settled Amount Bank Reference All Transaction Details 4/9/2018 I/W RTGS PAYMTS 100 aaaaaaaaa asasdsasadasdsadasdasddsadasdasds 4/10/2018 NEFT INWARD 200 aaaaaaaaa asasdsasadasdsadasdasddsadasdasds 4/10/2018 TDS ON DEP...

Hi all, Apologies if this has been answered somewhere else but if it is, I can't find it. I'm setting up a budget spreadsheet where I download all of my transactions from my bank and run a little macro that automatically categorizes all of my transactions based on an existing table. So for...