This seems like it should be simple but, for the life of me, I can't figure it out.

I want to be able to enter text into a cell (let's say, cell B1) and have that exact text be inserted into another cell (let's say G48).

How can I get text entered into B1 to automatically appear in G48?

I don't have a lot of experience with macros so, if this is the route that I need to go, please over-explain if you don't mind. I'm not an excel 'idiot' but, I'm not anywhere near an expert.

Thanks for your help!

 

Not having MSFT Excel on this computer to try it out, can only take a guess:



G48: =B1

 

I just tried it, he is correct.

 

yep =B1 is all you need

 

I must have a setting wrong or something... it doesn't work for me.

If I put =B1 (which I've tried repeatedly prior to this post), it just displays =B1.

In cell properties, do I need to set that cell to something else?

 

Weird. I just tweaked the cell properties.... changed it from a 'text' cell to a 'general' cell and it immediately worked.

Thanks for the help guys... I knew it was simple.

 

check the formatting of the field and make sure it isn't Text...it needs to be general.

Right click on the cell, format...select general then delete the contents and retype =b1

 

LMAO... check my last response...

 

it wasnt there when I typed it I swear...

Just remember that Excel reads text formatting literally and wont change it