View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rocky Rocky is offline
external usenet poster
 
Posts: 18
Default Cross sheet reference function

Hey,

I'm a newbie to use Excel. I need to come up with a workbook has 2 spread
sheets in it.
The first sheet hold the project name, Time I spent on it, Date etc. I have
several projects in one day. In the second spread sheet I need to know total
hour I spent on the projects. I do not want to hand input the hours. Is there
a formula or function I can use so the hour information in the 2nd
spreedsheet could be updated automaticallly according to the data I entered
in the 1st sheet?

Thanks in advance!
Rocky