Copying cell contents

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Kitchens - 22 Oct 2004 14:07 GMT

I am using Excel 2000. I need to copy a name that is located on Sheet 1
cell A5 to a certain cell on Sheet 2. I was hoping to put a formula in my
Sheet 2 cell that would automatically place the name there for me, but so
far I haven't been able to get anything to work.

I don't want to use a macro for this. Can anyone please help?

Reply to this Message

VENKAT - 22 Oct 2004 14:12 GMT

in the cell in sheeet 2 type
=sheet1!A5

note exclamation mark <!> which is the key above tab

> I am using Excel 2000. I need to copy a name that is located on Sheet 1
> cell A5 to a certain cell on Sheet 2. I was hoping to put a formula in
[quoted text clipped - 3 lines]
>
> I don't want to use a macro for this. Can anyone please help?

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message

John Kitchens - 22 Oct 2004 15:21 GMT

When I try that it doesn't work.

I put: =sheet1!A5 into my cell on sheet 2 and now the cell just says
=sheet1!A5. I have no idea what I am doing wrong.

Can you try to help me once again?

Sheet 1 Cell A5 contains a person's name that I typed in. Just plain text.
(if that makes a difference)

Please help!!!!!

Sincerely,
John Kitchens

> in the cell in sheeet 2 type
> =sheet1!A5
[quoted text clipped - 11 lines]
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message

VENKAT - 23 Oct 2004 04:19 GMT

one problem may be that the cell in sheet2 may ba already
formatted(perhaps as text). highlight that cell and click exit-clear-all
(DO NOT merely hit delete key) then type
=sheet1!a5
see whether you succeed and let the group know
==============

> When I try that it doesn't work.
>
[quoted text clipped - 30 lines]
>> --
>> Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Signature

Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

Reply to this Message

John Kitchens - 22 Oct 2004 15:21 GMT

I kept trying it, and I finally got it to work. I think I had some cells
merged and that was the problem.

Thank you so much or all of your help!

Sincerely,
John Kitchens

> I am using Excel 2000. I need to copy a name that is located on Sheet 1
> cell A5 to a certain cell on Sheet 2. I was hoping to put a formula in my
> Sheet 2 cell that would automatically place the name there for me, but so
> far I haven't been able to get anything to work.
>
> I don't want to use a macro for this. Can anyone please help?

Reply to this Message