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...
Try this: (see attached file)
Upon pressing CTRL+R:
Scroll right to see a button to export that sheet into a new workbook, it will be saved on the same path file.
Oof, where's the file? Was sure I attached it. (first time using this UI)
anyway using the same site, here's the sample file:
https://filetransfer.io/data-package/gdW9CApr#link
I have received your file.
As I have no windows PC on hand to test macro,
I posted some links and similar VBA codes for your reference.
