close

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

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()