Hi ExcelForum members,
I am newbie on macro. I just doing macro sometimes by using recording macro then stop. I really don't how to code manually.
I have a problem on my workbook. My boss want a format that every time my staff record receipts from sales on account, it will highlight the row which customer paid on the other sheet which is the summary of 'Sales on Account'.
For clear view of my problem, here's my file trial.xlsm.
You can see there the sheet name; Total and Receipts.
The Total(sheet) contains summary of sales. The Receipts(sheet) contains payment of customers. Every payment recorded in the sheet Receipts, it will highlights the row of customer on the table located at sheet Total.
Please help me
Bookmarks