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.