Hi.
I fill my timesheets in a excel document.
There is a new document for every new week..
There is a new folder for every year.
All documents starts with the word quot;Ukequot;, and then week number,
or maybe weeknumber with additional info...
I want to have an overview of hours i have quot;worked inquot;, and hours i
have taked time of.
My idea of how it could be done is to use my quot;clear listquot;.
If I could use some cells there to either look for all documents in
a certain folder (year 2006, 2007 etc...), or look for all documents
that
start with quot;Uke...quot;.
Then I would like it to add up a certain cell from all of the
documents..
So when i put a new week-document in that folder, it will automaticly
add up all my worked in hours, and all my time of..
Get my point??
Is this possible, and =IF(yes=1;quot;How?quot;;quot;Are you sure??quot;)--
Fjatle
------------------------------------------------------------------------
Fjatle's Profile: www.excelforum.com/member.php...oamp;userid=33777
View this thread: www.excelforum.com/showthread...hreadid=535510
- Jun 04 Wed 2008 20:44
Use cells from other documents..
close
全站熱搜
留言列表
發表留言
留言列表

