Ok so this is a little confusing.
I have a workbook that tracks statistics for 9 managers across each week of the year. Each manager has their own set of worksheets for each week that get totaled up on a shared worksheet at the end of each month. Of course someone ruined all of my formulas that add up each managers' totals on an end of month tab. Now the workbook template is due Friday and I do not have time to manually do all formulas again. I was wondering if there is a way, I was thinking VBA, to have excel automatically put each formula in?
Each formula will be pulling from the same cell just from different worksheets. I've tried naming the cells and such, but that does not save much time.
I appreciate any help...
I have a workbook that tracks statistics for 9 managers across each week of the year. Each manager has their own set of worksheets for each week that get totaled up on a shared worksheet at the end of each month. Of course someone ruined all of my formulas that add up each managers' totals on an end of month tab. Now the workbook template is due Friday and I do not have time to manually do all formulas again. I was wondering if there is a way, I was thinking VBA, to have excel automatically put each formula in?
Each formula will be pulling from the same cell just from different worksheets. I've tried naming the cells and such, but that does not save much time.
I appreciate any help...