Importing data from one worksheet to another in Excel 2000

  • Thread starter Thread starter GooglePoster
  • Start date Start date
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.
 
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...
 
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...
 
Back
Top