Printable View
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?
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
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.