Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate cells automatically
Hi,
I would like to populate 2 cells with the words Sat and Sun respectively if all weekdays are selected in other cells. What's the best way of doing this? Example A1 = Mon B1 = Tue C1 = Wed D1 = Thu E1 = Fri If cells A1 to E1 have that combination, then F1 to automatically populate with Sat and G1 to populate with Sun. If A1 to E1 does not have that combination, F1 and G1 to remain blank. Is this possible automatically? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Populate cells automatically
On 23-Jan-2008, ?B?am9uIGJveQ==?= wrote: I would like to populate 2 cells with the words Sat and Sun respectively if all weekdays are selected in other cells. What's the best way of doing this? Example A1 = Mon B1 = Tue C1 = Wed D1 = Thu E1 = Fri If cells A1 to E1 have that combination, then F1 to automatically populate with Sat and G1 to populate with Sun. If A1 to E1 does not have that combination, F1 and G1 to remain blank. Is this possible automatically? Conditional IF, or a macro, are possible ways. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Name Automatically Populate | Excel Worksheet Functions | |||
Automatically Populate Fields | Excel Discussion (Misc queries) | |||
how do you have information from one tab automatically populate i | Excel Worksheet Functions | |||
how to automatically populate cells using lookup tables | Excel Discussion (Misc queries) | |||
I wish to automatically populate cells with list data when a item. | Excel Discussion (Misc queries) |