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

[circuit_breaker]

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.

 

[John]

Hi
Remove the $ sign on the letter N$2 and drag the cell as far has you need.
HTH
John

 

[circuit_breaker]

It works! Thanks very much

Hi
Remove the $ sign on the letter N$2 and drag the cell as far has you need..
HTH

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 -

 

[John]

Your Welcome
All the best for the NewYear
John
It works! Thanks very much

Hi
Remove the $ sign on the letter N$2 and drag the cell as far has you need.
HTH

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 -

 

[Gord Dibben]

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


Gord Dibben MS Excel MVP

It works! Thanks very much

Hi
Remove the $ sign on the letter N$2 and drag the cell as far has you need.
HTH

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 -