View Single Post
  #1   Report Post  
Excel'ed Failures
 
Posts: n/a
Default 3-D refrence made easy? Please help me out!

Hello,

Currently I am working on a project that shows the -/+ of parts made by
certain departments in our facility. For example Department's "A" target was
10 and they only made 5 so they would be -5. This is done for 6 departments
and is recorded on 31 diffrent tabs (for every day of the month) on the same
worksheet. My question is that I would like to use a 3-D reference showing
the running total of -/+ actual achievements. Is there a easier way of than
typing in the formula for all 31 tabs? Typing in that tab 2 looks at tab's
1's data and tab 3 looks at 2's 31 times seems like I am doing this the long
way! Thanks in advance!