credit

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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