This isn't a function it is a way of referencing a cell in another workbook.
It is part of a function.
On the same worksheet you would use
=A1 or =sum(A1:A4)
on a different worksheet in the same workbook
='sheet2'!A1 or =sum('sheet2'!A1:A4)
to a different workbook
='[workbook2.xls]sheet2'!A1 or =sum('[workbook2.xls]sheet2'!A1:A4)
"madduck" wrote:
This function did not work or I'm not doing it right any other suggestions?
"Joel" wrote:
The general form of a referenced cell is a follows
'[c:\my workbook.xls]My worksheet'!A1:B7
Note that the single quotes are needed only if there arre spaces in the
workbook name or the worksheet name.
"madduck" wrote:
I am doing Time caps for my company with column A listing the names of the
employees and row 3 is the date.
In each other field there is a number of hours worked for each individula
employee In the one workbook it is setup on a by-weekly format the current
one is for March 24th to April 6th I want to be able to type the information
into this workbook and have it also show up in the Monthly workbook that I am
also working with.
Is there any formula that would let me do this easily without having to copy
and paste each selection.
I have a thought of what it could look like but I'm not sure how to
accomplish it.
I.E. have the formula search the by-weekly workbook for a particular date
then find each individual employee and enter the corisponding value similar
to a times table setup find 3/11/07 across the top then down thr left side
find the appropiate name then enter the value.
Is this even possible.
Please Help
not much hair left to pull out.
Kelly