Hello Excel Gurus.
I need help to come up with a VBA Macro for my Excel worksheet.
I have a workbook with 2 sheets, [TR Sheet and Masterlist sheet]
The TR sheet has 4 columns where I type the data.
The Masterlist has 9 columns where I will post the data coming from TR sheet. If the TR Type is RETURN, the QTY will be added to Masterlist and if the TR Type is BORROWED, the QTY will be deducted from the Masterlist. Also, the Notes on each item will be copied to the Masterlist. Once the TR sheet data is posted, data must be erased so that there will be no double transaction. My purpose is to key the items on the TR sheet and merge the items on the Masterlist instead of keying it directly on the Masterlist because there are more than 500 items on the list. I have attached a Sample screen shot before and after the posting or running the code.
I hope somebody can share their expertise. Any clarification, please let me know.
Thank you.
Bookmarks