Hi Richard, What I want to do is have selected cells from 1 spreadsheet automatically populate another sheet. Both sheets will be open simultaneously. I've done this in Lotus 123 using +<<C:\Misc\Aset1210.123>>A:E1..A:E1 but I can't figure out how to do it in Excel 2002.
Thanks in advance for your help,
John

---

Answer from Richard Rost:

You can refer to a value on another sheet like this:

=Sheet3!B4

This will get the value from Sheet3 in cell B4.

You can get whatever values you like this way. Now, when you say "selected cells," if you want to have Excel automagically copy and paste this data to another sheet, that would involve a macro - which is a little more in-depth than I can go into here.