| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate cells automatically | Excel Discussion (Misc queries) | |||
| automatically populate cells | Excel Discussion (Misc queries) | |||
| Filling a few cells based on the info from another worksheet. | Excel Worksheet Functions | |||
| how to automatically populate cells using lookup tables | Excel Discussion (Misc queries) | |||
| How do I select cells and make the info populate into a form? | Excel Worksheet Functions | |||
Linear Mode
