It is an Excel book, for the personnel department of a company, which contains several sheets, in order to follow up the monthly payroll. The Excel book presents a monthly sheet, keeping a total of 24 sheets, two years. Within each sheet, we find a column for each month of the year, in a correlative way, that is, if we are in April, the columns from April of the previous year to April of the current year are shown.
Our client, asked us to make some macros to add new sheets and remove the old ones and, also to add and remove columns, to the summary sheet. The intention was to maintain, in the most automatic way possible, the creation of new months and their correlation, with respect to the previous sheets/months. The design of the spreadsheet is up to the client.
We show a picture of one of the monthly sheets:
We show an image of the summary sheet:
Application made with Excel. To use this application you need to have the MS Excel program. The application is made in Spanish language. Note: The data inserted in the images are fictitious.
