transactions

Hi, I have a worksheet in Excel that is a log of transactions (after we run a process, we paste the log information at the bottom to maintain all history) What I would like to be able to find out and include in a separate worksheet in the same workbook file, is how many Unique end users did we...

I use Google Calendar with a script that counts up the revenue. I use Wave accounts to import bank transactions. I does 3 lots of tax including US, tax credits and UK self assessment. Please let me know if there is anything suitable? Thanks

Hi, I have a pivot table, Date is one of the columns, however, if there is more than one transaction in the same date, the table will only show date on the first transaction but blank date for all other transactions in the same date. Technically it is fine, but for presentation, I would like...

I have a table of transactions with sales people that is cleaned and sorted so all transactions for a sales person are together in column A. In PQ, I would like to insert a blank row after each change in agent....similar to the subtotal function in Excel, except I would like to add a blank row...

Hi Folks, I'm hoping somebody can help me. I have a workbook that has rows of transaction data with each row being a transaction. The transactions relate to a number of clients. I currently use the following code to filter the clients by account number so all the transactions for one client...

Hi guys For work I have to keep an Excel version of our company card bank statement and day by day I have to update it, and then annotate it on Excel with notes. When exporting the Excel version of the bank statement, sometimes the order changes and a transaction or two appear amongst...

I've created a macro that's supposed to: 1. get the account numbers from another sheet, together with their transactions 2. de-duplicate account numbers 3. calculate the number their transactions, dependent on the transaction status (pass, review, reject) 4. allocate customers to the sales...

Hi, I have the following code with which I am getting error with the red text: It may be complicated so let me briefly explain. I am using the countifs function to get a number from a column from another sheet called "Pending Transactions Count" and subtracting another number from a different...

Hi, I need some help adding Data Validation in VBA. I would like it to reference a whole column in a separate worksheet but I get an error in the formula1 line. How do I fix this? I also tried ".Range("I:I")" but that also doesn't work. Sub DataValidation()...

I have converted bank statements from PDF to Excel and now need help identifying the vendors in the line detail of the transactions. I can clean up some statements using Text to column but need help separating the vendors from the other text. Any help would be greatly appreciated. Once I have...

I currently have a worksheet with 277 rows of data. (One header and 276 transactions). I would like to limit each worksheet to 101 rows of data. (Header and 100 transactions). For example, instead of having 277 rows in Sheet 1, I would like Sheet 1 to have 101 rows (header and 100 transactions)...

Hey All! Newbie to VBA, first time poster! Looking for help on how to write a VBA script that will delete subtotal groups equal to zero. We are implementing a new system and starting a new process for a goods received but not invoiced account and this will be a a way of reconciling the...

Hi. My apologies for asking a question that seems to get asked frequently. However, I was not able to figure out a solution from the previous posts, and I have not been able to find a video on the Mr. Excel or ExcelisFun youtube pages that go over "Duplicates" errors in Power Pivot. I am hoping...

Hi All, I've got a problem that I suspect has probably been asked before, but I can't find anything on it, so I'm starting a new thread. I have a series of accounts which need to be reconciled. That is, an account may be made up of hundreds of transactions but the majority of them net to...

Hi there, I have been asked by someone in my organisation to try and improve an excel file they use for managing account transactions. They basic format is this: We generate a tab delimited TXT file from our banking portal which lists all of the transactions made for the month. This is then...

So this is my first time posting on here but I was hoping I could get some help with an issue I keep having to deal with and I am sure there is some excel formula that could make this way easier. I am at a client who switched General Ledger software mid year and it's caused some issues. What I...

Hi everyone, I'm trying to filter all the transactions of a customer with a VBA command. In the statement sheet I want to display, when I manually enter a date range, the transactions that took place on these date with the customer number and its name? And this, with the help of a button that I...

I have a strange situation, have a query that reads monthly transactions from CSV (1 file x month) from a folder. Right now there are only 2 years, but it will continue to grow. I have 1 file (june 2017) in which 2 transactions exist in the CSV but the amounts (everything else loads) do not...

Hello, I want to have a header print out based on the current month/year with the worksheet tab and "transactions" included. I've tried this, .CenterHeader = "&A &D Transactions" I currently have this, but I cannot figure out how to add the word Transactions, or the worksheet tab name...

Can someone please help me? I wish to calculate the number of occurrences for each trader where the streak of the declared number of trades (I used the variable 5 here) resulted in a winning percentage greater than the hurdle rate (I used 60% here). So for Dan, there was only one time...