I am designing a workbook to consolidate my staff claims based on their travel and entertainment expenditure.
I would like them to key-in their monthly expenditure in their individual worksheets ("Tom", "****" and "Harry") - if there were any travel- or accommodation-related details, to provide further details. If there is more than one incidence of travel/accommodation, they can click the "Add More" macro button to fill-in the relevant details.
What I would like to happen after they are done with their monthly claims is to click on another button - titled "Post" - to have their details posted to the "Consolidated" worksheet.
I have provided an example of the envisaged outcome in the attached spreadsheet titled "Example".
Appreciate your help on the code to effect the "Post" button. Thanks.
Bookmarks