transaction

Hello, I have an issue and I desperately need your help. I have two tables with orders (a trasaction number is a unique value) and another table with sales invoices (several invoies can be issued to one transaction number). The tables are linked via transaction numer, however when I create a...

Hi Everyone, I have a table where I'm trying to lookup a transaction ID for a particular sales member. I'm not sure how to approach this and my efforts around an IF( AND( VLOOKUP( formula have proved futile. The following tables show what I'm trying to accomplish. TABLE 1 <tbody>...

Hi All, I'm using the following formula but want to add the criteria to show only negative values. Can you please let me know how the new formula will have to look? =SUMIFS('Pivot -'!G:G,'Pivot -'!B:B,B2,'Pivot -'!C:C,"NHR TWS Transaction",'Pivot -'!D:D,"A*PAINT-ORD",'Pivot -'!A:A,A2)+...

Would greatly appreciate it if someone could provide a prorating formula. What I want is to prorate the amounts in D2 over the values in C2. There are multiple transactions in column A and for each transaction, there can be anywhere from 1 to several lines (column B), with each line having value...

Can I record one macro for all processes I need -- (1) Select entire column [Column V], cut it and insert it somewhere else [Column N]; (2) Sort entire sheet according to header "Transaction Type' [Column N now]; (3) Perform Subtotal at each change in "Transaction Type [Column N now] and...

Hi, I have set of transaction data that has various fields such as name, date, amount (and various other attributes of the transactions). I have 4 pivot tables that splits this data into different sets of data (mainly divided by transaction types like buys, sells, fees, etc.). the pivots have...

Hello, I have a pretty complicated requirement and need some help. My business users receive a credit card file from our vendor and use this file to reconcile against data that is loaded into our financial application. The file has no column titles however has several different header...

Good afternoon Excel Wizards, Another fun Excel challenge here. Please consider the following: I have a sheet named "Confirmed Movement" that lists Rank numbers in column H, Group names in column I, Month names in column Q, Transaction types in column O, Transaction dates in column P, and...

Good afternoon Excel Wizards, Another fun Excel challenge here. Please consider the following: I have a sheet named "Confirmed Movement" that lists Rank numbers in column H, Group names in column I, Month names in column Q, Transaction types in column O, Transaction dates in column P, and...

Alright, I have a project I'm trying to drum up for monthly budget stuff. I pull down a monthly transaction history from the bank. date, desc, category, amount for the 4 fields. That goes into tab 1 per se. But my wife really prefers to see things on a calendar type layout vs just a list...

Scenario: I download a monthly statement each month The statement has transaction dates. I give each line of the statement a category. I want to analyse the statement by month using a PivotTable. Each month when I download a new statement, I want to add this into my PivotTable that consolidates...

how to match data from 2 financial statements by amount and date ? So i have a transaction at Date 1/1/18 with the amount of $4000 and in the other statement i have the same transaction amount and date, how to use a formula to run through the data and pick out not matching ones.

Hi, I have an example of a table below that is retrieved from a web based platform in a .csv format. The problem I'm having is that the "Transaction Date" field can show 2 different formats (examples below) and neither of which are in a date format. They come to me as a European format, not US...

Hello, Here's what I'm trying to do: - WHAT I NEED TO DO: From "Transaction Codes" sheet take each "X" transactions codes (X= number of total codes), listed in the first column (not all rows have a transaction code) and enter them on "Checkbook" tab and add additional data - HOW I WANT TO DO...

Please see below data pulled off a system. Data gives a date and time which I converted to simply HOUR and then the transaction figures. As seen in C2 and C3 there were two transaction amounts (16.76 and 15.00 ) at 09:23:02. Problem is when I want to create a pivot to see total transaction...

Hi All, Trying to find a VBA solution to the following and think I need to use DAO but not sure how to. I have a table that has a daily summary of transactions (sas.summary) including date, transaction reference and transaction type. I also have a table for each transaction type (approx 250...

I am sending this from my phone so I am unable to post any screenshots etc. sorry. I am trying to create an Inventory and sales database. I have loosly used the Microsoft Northwind template as a guide. I have a Sales form with a Sales Detail sub form. The sales form creates a new record on...

Hi, I have a list that is broken down by Transaction, but I need to change the orientation of it so the list is by the product (even if there are duplicate items) with all of the corresponding information from that specific transaction. Since I'm not great at explaining I'll just get right...

Hello board! I am trying to figure out how I can get two tables to talk to each other but the second table only contain specific data. I have a master dataset of transactions but I want to also have a separate table containing only one type of transaction so I can build summaries from it. This...

Hi! I have a list of data that has Product Names in one column, date in the next, and finally Transaction amount in column C. I am trying to find the Total Transaction Amount by month and product. How can I do this? Example: <tbody> Product Name Date Trans Amt Red 1/3/17 5 Red 5/15/17...