Long time ago I found myself as the sole point of contact between 200 managers+workers office & regional HR office. I had recently came across excel, so made a simple sheet with names & staff numbers. That sheet, over the time of 3 years, evolved into a mammoth of sheet. sheet with db_ prefix listed names, joining date, title, salary, timebase, country of origin, skills, driving license number, expiry & many such. Other sheets pull up some columns, & I manually add D for day shift in date column, or N for night, H for holiday, F for Friday. Another one pulls this data per week for D only or N only or both. Another one pulls data & prefills the leave request sheet for individual staff. At any time I change the dropdown week value, & I can print a summary of man hours, who worked, how much expenses on HR. No where in the sheet I used VBA because of that macro dialog box.