Getting a value from another worksheet, in a copied cell?
 

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.

Getting a value from another worksheet, in a copied cell?
 

Hi
Remove the $ sign on the letter N$2 and drag the cell as far has you need.
HTH
John
wrote in message
...
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.

Getting a value from another worksheet, in a copied cell?
 

It works! Thanks very much :)

On Jan 13, 8:54*am, "John" wrote:
Hi
Remove the $ sign on the letter N$2 and drag the cell as far has you need..
HTH
wrote in message

...



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.- Hide quoted text -

- Show quoted text -

Getting a value from another worksheet, in a copied cell?
 

Your Welcome
All the best for the NewYear
John
wrote in message
...
It works! Thanks very much :)

On Jan 13, 8:54 am, "John" wrote:
Hi
Remove the $ sign on the letter N$2 and drag the cell as far has you need.
HTH
wrote in message

...



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.- Hide quoted text -

- Show quoted text -

Getting a value from another worksheet, in a copied cell?
 

To see why it works, go to help on absolute and relative references.


Gord Dibben MS Excel MVP

On Tue, 13 Jan 2009 05:59:48 -0800 (PST), wrote:

It works! Thanks very much :)

On Jan 13, 8:54*am, "John" wrote:
Hi
Remove the $ sign on the letter N$2 and drag the cell as far has you need.
HTH
wrote in message

...



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.- Hide quoted text -

- Show quoted text -