I need some help with the attached spreadsheet. Columns D:M, creates my hierarchy rollup with Employee ID numbers. Columns W:AF are the names associated with the employee ID#'s. This rollup is from the employee up to the CEO.
Columns AG:AP is the hierarchy from the CEO down to the direct manager. I've added a lot of formulas to make this happen, but whenever I need to refresh the data, it takes about 2 hours out of my to do this process. It stalls from 15-20 to recalculate.
Is there another to get the Bottom Up and Top Down hierarhy that would require a simplier formula or a macro I have to refresh 3 of these twice a week and waiting on the form to save or calculate is very counter productive
Related question: http://www.experts-exchange.com/Q_28522751.html