Importing data from one worksheet to another in Excel 2000

G

GooglePoster

Hello,
In Excel 97, I was able to import data from one worksheet into another
with something like this:
='C:\EXCEL\[DCARE98FEES.XLS]DCARE98FEES'!$H$19
where I was able to obtain the value currently in cell H19 of that
worksheet and place this value into a cell on another worksheet.

Now, I am running Excel 2000, and tried to copy the exact, changing
the filename/pathname, and am unable to do so. The exact filename and
cell reference that I am attempting to use is as follows:

C:\My Documents\BusinessTaxWorksheet2003.xls, cell I4

Is it perhaps related to the space in the filename, and I need some
more quotes, etc?

Thanks for any assistance.

I searched both in Excell 2000 and online, and did not find exact
information on how to do this.
 
D

Dave Peterson

The easiest thing to do is to open that other workbook.

Then go to your cell that gets the formula.
type = (equal sign)
traverse to that other workbook's worksheet cell I4.
Hit enter.

Close that other workbook and you'll see the formula.


Hello,
In Excel 97, I was able to import data from one worksheet into another
with something like this:
='C:\EXCEL\[DCARE98FEES.XLS]DCARE98FEES'!$H$19
where I was able to obtain the value currently in cell H19 of that
worksheet and place this value into a cell on another worksheet.

Now, I am running Excel 2000, and tried to copy the exact, changing
the filename/pathname, and am unable to do so. The exact filename and
cell reference that I am attempting to use is as follows:

C:\My Documents\BusinessTaxWorksheet2003.xls, cell I4

Is it perhaps related to the space in the filename, and I need some
more quotes, etc?

Thanks for any assistance.

I searched both in Excell 2000 and online, and did not find exact
information on how to do this.
Click to expand...
 
G

GooglePoster

Dave,
Thank you for the prompt reply to this issue; I appreciate it.
That certainly is an easy way to link data!

Dave Peterson said:
The easiest thing to do is to open that other workbook.

Then go to your cell that gets the formula.
type = (equal sign)
traverse to that other workbook's worksheet cell I4.
Hit enter.

Close that other workbook and you'll see the formula.


Hello,
In Excel 97, I was able to import data from one worksheet into another
with something like this:
='C:\EXCEL\[DCARE98FEES.XLS]DCARE98FEES'!$H$19
where I was able to obtain the value currently in cell H19 of that
worksheet and place this value into a cell on another worksheet.

Now, I am running Excel 2000, and tried to copy the exact, changing
the filename/pathname, and am unable to do so. The exact filename and
cell reference that I am attempting to use is as follows:

C:\My Documents\BusinessTaxWorksheet2003.xls, cell I4

Is it perhaps related to the space in the filename, and I need some
more quotes, etc?

Thanks for any assistance.

I searched both in Excell 2000 and online, and did not find exact
information on how to do this.
Click to expand...
Click to expand...
 
Top