I'm using excel 2000 at work and excel 2007 at home to try to find an answer,
but I haven't found on yet.
I have a workbook with data refering to numbers of pages from a copier in a
month that is listed per day. I have another workbook that has the days of
the month for sheets, and number values for wasted product.
the wasted product numbers are in cells D2:D8. I need them to go into
differnet cell on the other workbook: K5,K15:K17,K25
Workbook one is called Product list, January 08 (as sheet 1) {Where I want
information to go}
Workbook 2 is called Wasted Paper, 1/1/2008 (as sheet 1) {where I need
infomation to come from.}

The formulas I have looked at so far have been "cell" and "hyperlink", but
don't seem to do what I want them to do. Hyperlink, from what I understand it
to do, despalys a link to the refrenced cell, worksheet, url, ect; and cell,
from what I understand, gives back coded data from a refrenced cell, not the
actual data in that cell.

Any help would be Appreciated

Other than using "hardcoded" direct link formulas, eg:

In your book: Product list.xls
In sheet: January 01
you could have in say, A2:
=IF('[Wasted Paper.xls]1 1 2008'!A2="","",'[Wasted Paper.xls]1 1 2008'!A2)
with A2 then copied across/filled down to return the link values as required

Note: The above link formula assumes the source book: Wasted Paper.xls is
open simultaneously, with links to be done from a sheet: 1 1 2008
(think Excel 2003 will reject a sheetname such as: 1/1/2008)

Perhaps INDEX/MATCH might provide a better way
Check out Debra Dalgleish's nice coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH
There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Teryn" wrote:
I'm using excel 2000 at work and excel 2007 at home to try to find an answer,
but I haven't found on yet.
I have a workbook with data refering to numbers of pages from a copier in a
month that is listed per day. I have another workbook that has the days of
the month for sheets, and number values for wasted product.
the wasted product numbers are in cells D2:D8. I need them to go into
differnet cell on the other workbook: K5,K15:K17,K25
Workbook one is called Product list, January 08 (as sheet 1) {Where I want
information to go}
Workbook 2 is called Wasted Paper, 1/1/2008 (as sheet 1) {where I need
infomation to come from.}

The formulas I have looked at so far have been "cell" and "hyperlink", but
don't seem to do what I want them to do. Hyperlink, from what I understand it
to do, despalys a link to the refrenced cell, worksheet, url, ect; and cell,
from what I understand, gives back coded data from a refrenced cell, not the
actual data in that cell.

Any help would be Appreciated

I have briefly tested opening both workbooks and just clicking on the cell
that I want the information in, and then the cell that the information is
coming from in the other workbook, but it was on two test workbooks, and not
the actual ones needed and it worked. However, both workbooks where open, and
I would like it to work with information going to the one receiving with it
being unopened, just pulling the data from the saved file. Unfortunately I am
using excel 2007 at home and 2000 at work. I will take a look at the web
page.
Thank you for assisting.

"Max" wrote:

Other than using "hardcoded" direct link formulas, eg:

In your book: Product list.xls
In sheet: January 01
you could have in say, A2:
=IF('[Wasted Paper.xls]1 1 2008'!A2="","",'[Wasted Paper.xls]1 1 2008'!A2)
with A2 then copied across/filled down to return the link values as required

Note: The above link formula assumes the source book: Wasted Paper.xls is
open simultaneously, with links to be done from a sheet: 1 1 2008
(think Excel 2003 will reject a sheetname such as: 1/1/2008)

Perhaps INDEX/MATCH might provide a better way
Check out Debra Dalgleish's nice coverage on INDEX/MATCH at her:
http://www.contextures.com/xlFunctions03.html
INDEX/MATCH
There's also some sample workbooks available for d/l & study
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Teryn" wrote:
I'm using excel 2000 at work and excel 2007 at home to try to find an answer,
but I haven't found on yet.
I have a workbook with data refering to numbers of pages from a copier in a
month that is listed per day. I have another workbook that has the days of
the month for sheets, and number values for wasted product.
the wasted product numbers are in cells D2:D8. I need them to go into
differnet cell on the other workbook: K5,K15:K17,K25
Workbook one is called Product list, January 08 (as sheet 1) {Where I want
information to go}
Workbook 2 is called Wasted Paper, 1/1/2008 (as sheet 1) {where I need
infomation to come from.}

The formulas I have looked at so far have been "cell" and "hyperlink", but
don't seem to do what I want them to do. Hyperlink, from what I understand it
to do, despalys a link to the refrenced cell, worksheet, url, ect; and cell,
from what I understand, gives back coded data from a refrenced cell, not the
actual data in that cell.

Any help would be Appreciated

Welcome, Teryn
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---