Cut out cutout from my address and send me your e-mail address and I'll send
you a sample of what I think you're looking for.
DON'T post any addresses in these groups ! ! !
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"blausen" wrote in
message ...
I checked all of the links and found that they do link to each cell in
the same row. (EXAMPLE: I am linking only to Column J Cell 2 (as my
start) and then I allow EXCEL to copy the link downwards by grabbing
the handle in the lower right corner and then dragging it down to all
of the cells below it until I reach the last employee)
However I do not have links to any of the other columns (IE. Column A,
Column B, Column C, ECT.) is this what you mean? That I need to have
links to these Columns also? If so that would negate the use of the
first page to average all of the other days and giving a quickly
viewable reference of all the other days of the month instead of
having to flip from one sheet to another sheet. This first sheet will
also (at a later date) be used to set up to use a chart so that
upper-management can see the trends.
EXAMPLE:
Sheet "Total Average"
A B C D E F G
1 Name Group Day 19 Day 20 Day 21 Day 22 Total Average
2 Charles MRC ='19'!E3 ='20'!E3 ='21'!E3 ='22'!E3 =AVERAGE(A2:E2)
3 Essie MRC ='19'!E4 ='20'!E4 ='21'!E4 ='22'!E4 =AVERAGE(A3:E3)
4 Kenya MRC ='19'!E5 ='20'!E5 ='21'!E5 ='22'!E5 =AVERAGE(A4:E4)
I know that these are not lining up like they would if they were in a
notepad with everything TABed. As you can see each of the days on this
sheet are linked to another sheet that coincides with a worksheet for
that specific day. Now when I try to add information to a day such as
Day 20 which would look like this:
EXAMPLE:
Sheet "20"
A B C D E E
1 Name Group Job 1 Job 2 Job 3 Average
2 Charles MRC 1 3 =IF(ISERR(AVERAGE(C4:I4)),"!",AVERAGE(C4:I4))
3 Essie MRC =IF(ISERR(AVERAGE(C5:I5)),"!",AVERAGE(C5:I5))
4 Kenya MRC 1 2 =IF(ISERR(AVERAGE(C6:I6)),"!",AVERAGE(C6:I6))
Once again this looks better pasted in to a notepad. As you can see
Kenya did not work any of the three jobs so there is no data placed in
her row, but we have information in Essie and Charles which would then
be averaged by Row E. This is where the problem comes in, I put David
in as a new hire on the 20th and then sort the sheet in Ascending order
by Column A, this will move all of the data in to correct alphabetical
order on sheet 20. With that done I go to sheet "Total Average" to
verify that the links also updated. This has so far not happened. I
have also not added David as of yet (which I will do later). Is there a
way to get these rows and cells to update so that they continue to pull
the correct averages for the correct people?
--
blausen
------------------------------------------------------------------------
blausen's Profile:
http://www.excelforum.com/member.php...o&userid=31785
View this thread: http://www.excelforum.com/showthread...hreadid=516059