I created a template for tracking performance measures of employees at my office. Supervisors previously updated all the information manually. The template has a hidden table of vlookup functions to pull performance metrics of a few years worth of pre-named files. It pulls all the data from...
I am fairly new to excel... I have linked monthly files with similar names(only changing the date) for 4 years in excel. The outside linked data is a team rollup and is updated at the end of each month. I'm linking it to performance of individuals represented by the new spreadsheet. I used a...