1. S

    Determine the oldest date of debit transaction in account, that hasn't been summed to 0 yet

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

    debits do not = credits due to rounding when using % to calculate

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

    Can Microsoft Access improve efficiency for the task described? Advice needed

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

    VBA move numbers

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

    Keeping the formula blank until data is entered

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

    Help to check balance account number

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

    VBA macro

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

    Improve VBA

    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" &...
  9. subrosumon

    Negetive and Positive to be match

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

    2 column matching (reconciliation)

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

    Move data from Debit to Credit side

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

    empty cells issue - possible formatting or formula issue

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

    Auto Replace Text after Pasting

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

    Help with matching data in two columns with a control number

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

    Formula or Macros to put Numbers from one column into One

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

    Userform listbox items to worksheet issue

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

    Highlight Rows Based on the Sum of Multiple Cells

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

    Print 2 worksheets into 1 pdf by vba

    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 &...
  19. A

    Auto Journal Entry Creation based on the bank statement download

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

    If cell contains text, VLOOKUP that text

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back