Automatically populate cells based on info in another worksheet
 

This is probably easy, but I just can't get it.
Here's the scanrio:
I have 3 worksheets: 1.Main(Contains info for 2 offices), 2. East
Office,3.West Office
I filtersd the Main sheet by office location and created the other two
worksheets.
What I would like to happen is, when I get an update on a room number, I'd
like to enter it into the Main worksheet, then have it automatically polutae
that info for the user in the other worksheet(either East or West).
Example: Joe Schmoe sends me info that his room# is 53. I enter that in
COlumn F in the Main worksheet and when I look in tye East worksheet under
Joe Schmoe, that info is already updated.

Automatically populate cells based on info in another worksheet
 

It sounds like you could add a formula to say = whatever cell number from
your main worksheet.

"Francis" wrote:

This is probably easy, but I just can't get it.
Here's the scanrio:
I have 3 worksheets: 1.Main(Contains info for 2 offices), 2. East
Office,3.West Office
I filtersd the Main sheet by office location and created the other two
worksheets.
What I would like to happen is, when I get an update on a room number, I'd
like to enter it into the Main worksheet, then have it automatically polutae
that info for the user in the other worksheet(either East or West).
Example: Joe Schmoe sends me info that his room# is 53. I enter that in
COlumn F in the Main worksheet and when I look in tye East worksheet under
Joe Schmoe, that info is already updated.

Automatically populate cells based on info in another workshee
 

Yeah, but I would need one that checks all the changes in the Main sheet. So
every update in the main sheet, would then update one or the toher East or
West worksheet.

"Mindy" wrote:

It sounds like you could add a formula to say = whatever cell number from
your main worksheet.

"Francis" wrote:

This is probably easy, but I just can't get it.
Here's the scanrio:
I have 3 worksheets: 1.Main(Contains info for 2 offices), 2. East
Office,3.West Office
I filtersd the Main sheet by office location and created the other two
worksheets.
What I would like to happen is, when I get an update on a room number, I'd
like to enter it into the Main worksheet, then have it automatically polutae
that info for the user in the other worksheet(either East or West).
Example: Joe Schmoe sends me info that his room# is 53. I enter that in
COlumn F in the Main worksheet and when I look in tye East worksheet under
Joe Schmoe, that info is already updated.