credits

  1. 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>...
  2. S

    Combinations and permutations

    I have some work, in an Excel spreadsheet. Create an excel where there are 22 players list and create all the possible combinations for 11 players team. The conditions are as below :- Create your Dream11 team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget...
  3. C

    Formula HELP!!?

    <tbody> remaining Old Contract Credits 10 Price 30 New Contract Credits 50 Price 25 Out of contract (no credits) Price 35 Remaining Credits 60 </tbody> Order <tbody> order 1 number of books order 2 number of books order 3 number of books Book 1 2 2 2 book 2 3 40 0 book...
  4. H

    SumIfs question

    Hello, I am trying to figure out how to create a formula that will feed into a different worksheet. I have most of it figured out but I am stuck at two parts. <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> AsOfDate BankId AccountNumber AccountName BaiControl Currency...
  5. N

    Is it possible to dynamically update an Excel Table and have the master report shrink and grow?

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

    IF statement

    Hello forum friends, I am having an issue with a formula that I need to modify. I think I am missing an IF statement? Not sure. I know that this is going to be a fairly complex formula and I will be grateful for any help that I receive. The formula in question resides on the 'income analysis'...
  7. V

    combination that nets to zero. and exclude others which are not zero

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

    VBA Import data from Excel to PDF text boxes

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

    IF Statement to find Grade Level

    Hi all! Our school require all students to have 23 credits to graduate. For the students to be in 9th grade, they must have less than 6 credits. To be in 10th grade they must have between 6 and 11.99 credits. To be in 11th grade, they must have between 12 and 16.99 credits. To be in 12th grade...
  10. A

    Live Total at Top of Worksheet?

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

    Automatic circle lettering

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

    Automatically letter debits/credits

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

    How to delete credits and debits off the same column?

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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top