S
Slave2Six
I have a template that I use to track productivity of warehouse
employees. This document contains 4 worksheets (weeks 1-4) and each has
six days (Mon-Sat) with the same layout (see attached pic). Cells A4-A21
on the first worksheet are referenced for each of the following days so
that if a new employee is added in the "X1" - "X6" cells (for example),
all other related cells across all four worksheets are automatically
updated.
So far, so good.
Where I am having a challenge is that I also have worksheets that
contain monthly reports for each employee. I would like to know if
there is a way to associate a tab name with Cells A4-A21 so that when
changes are made to these cells the tab names will automatically change
as well.
I am using Excel 2003.
+-------------------------------------------------------------------+
|Filename: sample pic.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5157 |
+-------------------------------------------------------------------+
employees. This document contains 4 worksheets (weeks 1-4) and each has
six days (Mon-Sat) with the same layout (see attached pic). Cells A4-A21
on the first worksheet are referenced for each of the following days so
that if a new employee is added in the "X1" - "X6" cells (for example),
all other related cells across all four worksheets are automatically
updated.
So far, so good.
Where I am having a challenge is that I also have worksheets that
contain monthly reports for each employee. I would like to know if
there is a way to associate a tab name with Cells A4-A21 so that when
changes are made to these cells the tab names will automatically change
as well.
I am using Excel 2003.
+-------------------------------------------------------------------+
|Filename: sample pic.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5157 |
+-------------------------------------------------------------------+