Hi,

I have 2 Excel (2002) documents. I get a value from another document
using this:

=+[Document_A.xls]Worksheet1!$N$2

Now, I just want to copy this into let's say, the next 10 columns but
the $N$2 part remains the same. I'd like it to be $O$2, $P$2, $Q$2
and so on...

I tried every type of copy-paste special things but no luck.

Thanks for your ideas.