transaction

Hi, Can you please help, I am trying to sumifs using multiple criteria including a date range. However it is returning 0.00 value. The date range seems to be the issue as when I remove this from the formula the other criteria works. Going around in circles and not sure what I am doing wrong...

please see exmple below: when I ran my macro its only copy data up to Transection number and not all way to part number and I want all the columns in my break-up files.. I know I messing somewhere and would appreciate the additional help. Thx a lot for your reply. Set rng = cll.Resize(limit...

Hello Everyone, I herewith posting one example in which I have two tables: 1 Transaction table 2 Range Table <tbody> Transaction Table Range Table Sr. No Product Amount Range Range Start End 1 Pr1 100 ?? 0-100 0 100 2 Pr2 200 ?? 101-200 101 200 3 Pr3 150 ?? 201-300 201 300...

Hi All. I'm new to the forums but am confident in excel and have a conundrum i'm hoping I can get some assistance with. I have a sheet containing transaction information (Sheet1) and a reference sheet (Sheet2) which lists items and price breaks. The number of price breaks is different per...

Hi. I have a tabel with a lot of customer financial transactions. One customer can easily have 100 transactions per year. Example: <tbody> Customer Year Amount 101 2018 250 101 2018 500 101 2018 300 102 2018 800 102 2018 300 102 2018 700 103 2018 600 103 2018 200 103 2018 100...

Hi, I have a spreadsheet where I am comparing two lists of chronological transactions based on their amount. For example column B has an amount for the transaction from the first list and column D has a transaction from the second list. In column C I have the formula '=B1-D1' and if they sum to...

Hi, I have supplier account transactions and with each invoice and payment I know what is outstanding balance but I want to check/get a formula where I can see at end of each month what as owed. The issue is for example in July last transaction was 15th July, in August the last transaction...

Hello, I have built a very basic sheet to monitor sales at an event we are running, almost a bit like a till system. We are scanning barcodes which will represent products and then a final barcode to "end the transaction" which can also count the number of transactions. What I'm trying to...

Hey guys, I have an issue I can't seem to figure out how to accomplish. I have two tables of transaction data. I want be able to look up if a certain transaction on table 1 (We'll Transaction A) is on table 2 BUT only if it occurs within 30 days of transaction 1 AND is within +-$500 of...

I have a Userform that transfers data, sort of. I need to change the code, as it doesn't do what I need it to do. What ends up happening is that it creates a new row at the end of the table (good!). What it doesn't do, is add the userform data to that new row, but instead overwrites the data in...

Hello, I am creating a worksheet to log certain transactions so that I can automatically get the data in other worksheets. I added a button to start a series of inputboxes to get information about the transaction. The transaction is always at 1 of 2 bank, let's say Bank A or Bank B. I know...

Hi all, Newbie here. I've browsed here previously but never posted - I've scoured the internet for potential solutions to this problem but so far have had no joy. Hoping you geniuses can help. Basically, I have a document I use to ensure transactions between an array of entities are classified...

I apologize for a duplicate/similar post, but my prior post was not answered correctly/sufficiently. I have a large data set, with 22 employees that tracks their daily transactions. I want to obtain a random sampling of 1 transaction per person from the prior day. Column A = Transaction Number...

Hi I need some help here - basically i want to lookup a list of bank transactions (sheet 2 column f on a row by row) and return the word "NEVER" in column G next to the transaction if it can match part of a word as found in Sheet 1 column A I need to find the unique words on sheet 1 (eg. smith...

Hi all, I'm very new to using Power Pivot, so there's probably an easy solution to this, but for the life of me, I can't figure it out... My source data contains a list of employee IDs with the number of hours charged on various transaction dates. I have added a column to my source data that...

Hello, I am trying to figure out how to calculate based on the following. The 'closed' date will be in Cell A2. If closed transaction on 7/27, pay on Friday 8/17 If closed transactor on 7/11, then pay would be on Friday 8/3. Any transaction that closed between the 1st and the 15th of the...

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

Hello, I am working on a macro that takes the data from my source worksheet (this includes a list of clients with unique supplier ID numbers, as well as dollar transaction amounts for multiple types of accounts) and organizes those transactions in a new worksheet by supplier ID, transaction...

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

Im a complete beginner to excel so need help with this urgently. I need to extract the DKK figure from the transaction cell to the DKK amount. is there a formula which is most suitable? Ive been doin this manually for 2 weeks! <tbody> Transaction DKK Amount <tbody> 400-2000-1001-653...