Forum Discussion
Help me with Formulas pls!
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 manually create separate sheets for each party and record their transactions, which is time-consuming.
See this is my master sheet and I make stocks like this
That month Jodhka made 4 transactions, so by searching in master sheet all over made manually my diff party list.
likewise i have to maintain 100+ party details, so anyone can help me reagarding this?
I would like to automate this process using VLOOKUP and VBA macros or anything. Specifically, I need help with:
- Using VLOOKUP to fetch transactions from the main sheet to individual party sheets.
- Writing a VBA macro to create separate sheets for each party and copy their transactions from the main sheet.
Any guidance or examples on how to achieve this would be greatly appreciated.
Thank you!
hereby attaching excel file too
https://filetransfer.io/data-package/beXdVs3F#link
Why not:
- Select all cells in your table
- Click the Insert Tab and click the Insert Table button (make sure you check the little box "My table has headings")
- Click the "Insert Slicers" button and check the boxes next to "Inward" and "Outward"
