Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Match Infomation
I want to format a whole column to match a list of co-workers, about 5-6,
initials who enter data on a particular worksheet. In other words an operator would open this worksheet enter some information and begin to initial a cell, this particular cell would automatically match information regarding formatting (like all caps) and match it. Q: What is the best way to do this? -- Thank you, Trying Hard |
#2
|
|||
|
|||
Match Infomation
You can use Validation in this column. Select a column you want, go to
Data-Validation, and in dialog box "Allow:" select "list". In Source field insert names of co-workers (Bob,Phill,Georg...) separated with comas. You can also put list in range, and in sorce box insert this range. When co-workers enters in list, they will need to select name for this column from dropdown list, without any typing. Another (easier) way... Excel will, after few occasion when name was entered, give you autocomplete option, same as you described. Be sure that in Tools-Options under Edit tab was checked option "Enable AutoComplete for cell values". "Trying Hard" wrote in message ... I want to format a whole column to match a list of co-workers, about 5-6, initials who enter data on a particular worksheet. In other words an operator would open this worksheet enter some information and begin to initial a cell, this particular cell would automatically match information regarding formatting (like all caps) and match it. Q: What is the best way to do this? -- Thank you, Trying Hard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Index | Excel Worksheet Functions | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
Find a match that;s not exact | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions |