Grouping Bank statement transactions Macro maybe?

[JLew33]

Hi all, this is my first post yet I always come here first to read up on solutions. I have a question of my own can someone help?

I get a bank statement as to which I must reconcile to a different spreadsheet grouping the transactions based on the company. In my sample, there are three parts
1. Being the Raw data
2. How I would like the data to be transformed, in my sample, there are two added columns(Highlighted in yellow), type and company, Type has two options, Deposit, and withdrawal, a rule could be quickly written for greater than zero less than zero, yet I am unsure if that is macro worthy playing into the end result. There is also a company which could contain, Daily Deposit, Visa, Gift Card, Discover, Amex, Postmates, Grubhub, Uber, Doordash, CC Fee, and ACH. I can tell the transaction based on their description.
3. The spreadsheet I must include in my monthly Profit and loss reports. This is the most important thing I need the macro to group the transactions within the bank column highlighted in yellow. they must be listed by date starting from oldest on top (ie 11.1.20) and newest on the bottom(11.31.20) assuming hypothetically today's date is 12.6.20.

I will forever be in your debt if this can be accomplished as it would save me days worth of time saved each month. Please let me know how I can reward you for your time whether it be a review or whatever.

[Trebor76]

Hi JLew33,

Welcome to the forum!!

The following are my comments to your requests which relate to the attached.

Type has two options, Deposit, and withdrawal, a rule could be quickly written for greater than zero less than zero

Refer formula in Col. D of Data Result tab

they must be listed by date starting from oldest on top (ie 11.1.20) and newest on the bottom(11.31.20)

Macro1 sorts the data in the Data Result tab by date in ascending order.

the most important thing I need the macro to group the transactions within the bank column highlighted in yellow

I have created an additional tab called Output Lookup that tells the code what column to use to put the amount in Col. B of the Data Result tab into the Spreadsheet Result tab. This will make the process easy to maintain. I have also shifted the categories across the Spreadsheet Result tab so the amounts being copied into it do not overlap a category below. I have also included the expense categories to be populated as well.

Regards,

Robert