Importing data from one worksheet to another?

[drumcode]

Hi all,
Just a small problem but it would be great if someone could solve it.
I know how to import data from a worksheet that is in the same exce
file, for example, I want to import the contents of cell C3:
=worksheetName!C3

But how can I do the same thing if I am importing from a differen
excel file?
It works for me in so much that it will prompt me to find th
datasource, but this is a painstaking process as, every time I open m
excel file, it asks me to update values, and I have to search for th
escel file each time.

Surely you can say something like:
C:\Documents and Settings\profileName\Desktop\Folder1\worksheetName!C3

I know the syntax above is probably wrong, but does anyone know how t
do it?

Thanks in advance,

Stev

 

[Zygan]

there is another post just recently that might help you
but here is some advice

open th two workbook e.g book1 and book2
click on a cell and press = change to book 1 and click a cell and pres
enter
should look like this

=[Book1.xls]Sheet1!$F$12

then click

EDIT > LINKS > STARTUP PROMPT > DONT DISPLAY ALERTS AND UPDATE LINKS

as long as the file stays in the same location and the name does no
change should work fine from the

 

[penri0_0]

If i am understanding the question correctly it should work exactly th
same way as if you are importing from a different sheet in the sam
workbook.

So say in cell A1 of sheet1 in one workbook, hit your = key and selec
the cell in the other workbook you wish it to read with the mouse.
You should then find that in cell A1 of your original workbook it wil
read something similar to the syntax you posted.

You will be prompted each time you open workbook 1 if you want to lin
to the second workbook, and as long as you haven't changed the locatio
it should pick the data up straight away.

Hope that helps

 

[penri0_0]

Zygan has put it far more succinctly! :rolleyes

 

[drumcode]

Brilliant,
Thats a great help,
a simple enough solution in the end,

Cheers,

Stev