credit

  1. H

    Delete items whwre the debit and credit value and ref matches

    I have ref numbers in Col A and values in Col B where the debit and credit values match within one row of each other and the ref no. is the same or the ref contains the text Reverse in the aame row as the credit value, then the rows containing these items are to be deletes for eg B2 is 100...
  2. R

    Rows displayed dependent on cell value

    Hello! I need to create an excel sheet that will be filled in by individuals but the contents of the sheet are dependent on the answer of cell B2. If B2 is Yes then the below is displayed: <tbody> Credit Yes Name Surname Address </tbody> If B2 is No then the below is...
  3. A

    Copy from multiple workbooks to one work book.

    Hi, I have multiple excel sheets with information about daily invoices that need to be copied to a master creditors file only if that invoice is not paid. In that file we record the daily collection details also. So if it is under the heading of Credit collection, then those invoice numbers...
  4. 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...
  5. M

    Power Query reporting non-existent errors?

    My employer recently upgraded to Office 2016. I'm getting an odd result in PowerQuery. When I update a particular query from a macro file using ActiveWorkbook.Connections("Query - Financing").Refresh The connection window tells me that every row - 190 - has errors. But when I click on...
  6. A

    if lookup doesn't work...?

    Hi Excel Gurus, I have a list of invoice number such as: 12RD000252 15RC000564 18MD000548 18MC004512 type: RD deposit RC credit MD withdraw MC credit I would like to lookup the respective invoices whether it is a deposit or a credit or a withdraw.. I have the respective formula...
  7. C

    Transferring data to 2 different sheets from one main data entry sheet

    I have constructed a main data sheet where we can enter data for Return Good and Credit Memo. I'd like to have the info we enter to be transferred to the RGA sheet and the Credit Memo sheet. Then, I would like the sheet set up to where after we enter the data, we can "press" a macro button...
  8. E

    How to cut and paste to new column based on data in another column

    Hello, I saw this post by DK340; I need a macro that will loops through each value in column (K:K) and if the value, for example K1, is equal to "Credit Card", it needs to find the value in column B of the same row (in this example B1) and copies this value and then pastes this into cell A19...
  9. C

    Why is my SUMIFS formula with 2 "DNE" criteria (w/in the same row) acting as an "OR" instead of an "AND?"

    <style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style> <tbody> #D9D9D9[/URL] "]Name #D9D9D9[/URL] "]Tx #D9D9D9[/URL] "]Product #D9D9D9[/URL] , align: right"]Price #D9D9D9[/URL] , align: right"]Fees #D9D9D9[/URL] , align: right"]Total John Purchase...
  10. melodramatic

    Countif with or statement

    OK, I know this is easy, but it's escaping me today. I've got a Lottery table for our group, and part of my calculation of winnings distribution is dependent on how many people have played that month. January thru October is easy - if you paid, you played. About November, we start using our...
  11. C

    If, sumif, sumproduct????

    Good morning and thanks in advance for your help. I am trying to figure out what function to use and how to write a formula that will tell me If Bill Bob worked during week 1, and his name appears on the list of those that worked (sheet1!A:A), and that week has four 8 hour days as indicated in...
  12. G

    Macro HELP!

    Hello, I would like to create a macro-enabled template that will take the TOTALS (row) from each of the below columns and move them to the bolded section below. Thanks for any assistance you can provide! G <colgroup><col><col><col><col><col><col><col><col><col><col><col><col...
  13. J

    Currency Format

    hi i have this how can insert this line $ " & Format(Range("b9").Value, "$#,##0.00;($#,##0.00)") into this line of code: strsub = "TNW a/c #" & " " & ThisWorkbook.Sheets("Icube").Range("A7").Value & " " & "and" & " " & " " & ThisWorkbook.Sheets("Icube").Range("A8").Value & ", " & "Credit...
  14. F

    Time +/- calculation

    I am developing a flexi-working sheet for employees, and have run into a problem... For any time input cells, I have used [h]:mm as the cell format. However I need to generate a running balance (either a flexi credit, or a flexi debit). The sheet has 3 sections - Day; Date; Morning time...
  15. M

    Saving excel tabs in to seperate workbooks

    Hi i am new in here and also very new to VBA so I am doing a little self training and course but could do with some help quickly. I am looking for some code to save only the visible tabs in a workbook separately but I would like to name the file as the text in a cell e.g. I have two tabs...
  16. V

    How do you dynamically sum up a column and print sum to text?

    I have a work assignment to convert an excel file to text with specific number of spaces between each column because our older system does accept a direct import from excel. I have a column for gl codes and a column for amounts. here is what macro needs to print to text. if the "amount" is...
  17. J

    Trying to make a formula for credit

    I am trying to figure out how to make a formula for finding out the available cash advance credit I have on a credit card. So for example: Credit Line (Column I, Row 2): $200.00 Available Credit (Column J, Row 2): $1.81 Credit Line Used (Column K, Row 2): $198.19 Cash Advance Credit Limit...
  18. K

    Debits and Credits to offset in a column

    Hi, I have a large data that I exported in excel that include debit and credit in a column. I would like to find an easier way to pair the debit and credit to offset each other by a formula and easily find the variance. So the column would look something like this. Column A 250 400 350 -250...
  19. S

    Identify credits and debits within a week of each other

    Hi, I have a worksheet with multiple bank statement all combined together and sorted by date. Column E has the date, Column H has Debits and Column I has Credits, Row 1 has headers. I am trying to find a way of identifying debits and credits within a week of each other where the amount is the...
  20. J

    IF/OR Dilemma

    Hi everyone, I'm relatively new to formula chat so please bear with me, I'm trying to create a report that separates amounts if failing/succeeding on a system, Simply put, if there is data in a certain column (J) I have column (L) turn red and say the word "Fail" if no data is in column (J)...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top