Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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! |