excel 2000

[themanwhowas]

hi guys,

i am using excell 2000 and have several spreadsheets. 1 of these uses data from the other spreadsheets which change daily. is there some way that i can import specific cells from the other spreadsheets instead of laboriously copying and pasting or, dare i suggest, actually type?

[oldhermit]

This should give you an idea of what is involved.
If you are familiar with writing macros, then it is just a matter of including all spreadsheets and the ranges you wish to reference.
http://www.ozgrid.com/VBA/ExtractFromClosedWorkbook.htm

[General Winters]

If you want a cell in spreadsheet1 to equal the data in a specific cell in spreadsheet2 , then you could say something like ..

='location of file\[spreadsheet2.xls]Sheet number and cell

eg to reference cell b12 on sheet one of spreadsheet2.xls located on the desktop you would use.

='C:\WINDOWS\Desktop\[spreadsheet2.xls]Sheet1'!$B$12

When you open a spreadsheet that contains external references by default it should ask if you wish to update the values.