I am working on a personnel planning as part of a budget process. I have the staff data by name and other relevant static data then the data has multiple columns by type of benefit (Salary, Bonus, Medical, GPA etc). The data is also monthly so as to account for when new staff joins the organisation by month. I am attaching file with two tabs one in green where the plan is set and the other in blue trying to show how the output would look. I will appreciate any help offered. Thanks a lot. I believe VBA can solve my issue and is not complicated. I am only very weak in VBA but I love how they save time and all. Please find time to look into my thing and am happy to respond to any clarifications.
Bookmarks