Use cells from other documents..
 

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 "Uke", and then week number,
or maybe weeknumber with additional info...

I want to have an overview of hours i have "worked in", and hours i
have taked time of.

My idea of how it could be done is to use my "clear list".
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 "Uke...".
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;"How?";"Are you sure??")


--
Fjatle
------------------------------------------------------------------------
Fjatle's Profile: http://www.excelforum.com/member.php...o&userid=33777
View this thread: http://www.excelforum.com/showthread...hreadid=535510