Forum Discussion
Automating Party Transactions in Excel Using VLOOKUP and VBA Macros or anything
Hi everyone, I have a main sheet named "DAILY INWARD OUTWARD" that contains transactions for over 50 parties. Each party does multiple transactions, and I need to manage their stocks. Currently, I m...
Using VLOOKUP and VBA can work but seems a bit complex for this job. I might be able to help write a vba script that:
- Loops through each unique party.
- Creates a separate sheet for each party.
- Copies relevant transactions to their respective sheets.
Just let me know if you need that script.
As an alternative, I am working on a project where we are building AI Agents to automate data processing operations, such as data extraction, only based on user's prompt, and it's compatible with Excel, SQL, CSV, PDF, Word, TXT, Email. If you think that might be useful for you, our waiting list for our Beta release is open: https://www.starnustech.com/