[Gina]

I need text info (name and department) to automatically populate a cell in
Sheet 2, when I input the info into Sheet 1. Please tell me there is a way
to do this without writing code.

Thank you in advance.

[Bob I]

Select the Cell to be populated in Sheet 2, press =, click the Tab for
Sheet 1, select the Cell where the info is to be entered. Press Enter.

Gina wrote:

I need text info (name and department) to automatically populate a cell in
Sheet 2, when I input the info into Sheet 1. Please tell me there is a way
to do this without writing code.

Thank you in advance.

[Gina]

It populated the field with this: =Sheet1!C7

"Bob I" wrote:

Select the Cell to be populated in Sheet 2, press =, click the Tab for
Sheet 1, select the Cell where the info is to be entered. Press Enter.

Gina wrote:

I need text info (name and department) to automatically populate a cell in
Sheet 2, when I input the info into Sheet 1. Please tell me there is a way
to do this without writing code.

Thank you in advance.

[Bob I]

Correct, it would appear that you are planning to type your info into
Cell C7 on Sheet 1. Please do so, and observe that the info appears in
that cell on Sheet 2.

Gina wrote:

It populated the field with this: =Sheet1!C7

"Bob I" wrote:


Select the Cell to be populated in Sheet 2, press =, click the Tab for
Sheet 1, select the Cell where the info is to be entered. Press Enter.

Gina wrote:


I need text info (name and department) to automatically populate a cell in
Sheet 2, when I input the info into Sheet 1. Please tell me there is a way
to do this without writing code.

Thank you in advance.

[Gina]

I don't know what I did wrong before, but it does indeed work!!!

Thank you!

"Bob I" wrote:

Correct, it would appear that you are planning to type your info into
Cell C7 on Sheet 1. Please do so, and observe that the info appears in
that cell on Sheet 2.

Gina wrote:

It populated the field with this: =Sheet1!C7

"Bob I" wrote:


Select the Cell to be populated in Sheet 2, press =, click the Tab for
Sheet 1, select the Cell where the info is to be entered. Press Enter.

Gina wrote:


I need text info (name and department) to automatically populate a cell in
Sheet 2, when I input the info into Sheet 1. Please tell me there is a way
to do this without writing code.

Thank you in advance.

[Bob I]

You're welcome, have a great day!

Gina wrote:
I don't know what I did wrong before, but it does indeed work!!!

Thank you!

"Bob I" wrote:


Correct, it would appear that you are planning to type your info into
Cell C7 on Sheet 1. Please do so, and observe that the info appears in
that cell on Sheet 2.

Gina wrote:


It populated the field with this: =Sheet1!C7

"Bob I" wrote:



Select the Cell to be populated in Sheet 2, press =, click the Tab for
Sheet 1, select the Cell where the info is to be entered. Press Enter.

Gina wrote:



I need text info (name and department) to automatically populate a cell in
Sheet 2, when I input the info into Sheet 1. Please tell me there is a way
to do this without writing code.

Thank you in advance.