LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"