View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
mphell0
 
Posts: n/a
Default totals sheet- need summary of column of names between sheets


Do you have to leave the Name cell blank if they did not get paid in
that
particular month? If you leave their name in there and just list their
salary
as zero then your December sheet will have a list of all employees who
have
worked the previous year you can just put

=Dec 04!A6

I will have to think about it some more if you must leave them blank.


--
mphell0
------------------------------------------------------------------------
mphell0's Profile: http://www.excelforum.com/member.php...o&userid=30153
View this thread: http://www.excelforum.com/showthread...hreadid=508505