I've been using VBA in a limited capacity to help automate manual tedious jobs. However, I've run into something much more complex than my current abilities. I'm actually trying to eliminate hours of matching by building a macro that could possibly loop through the entire "Account #" list in Column "K", and be able to match multiple Debits (Column"F") against possibly multiple Credits (Column "E) and if there is a match, to highlight those matches (both column E and F) with a background color when a match occurs. I hope I explained this properly, but if you have questions, please feel free to let me know. I have attached a sample of my data. If something could be figured out, I could streamline this same VBA code against multiple accounts and save hours upon hours of time.
I would really appreciate any information, direction, or help someone has to offer!
Thanks!
Bookmarks