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