Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
linking columns for auto fill-in
I'm very new at this - I want to simplify filling in a timesheet. I have one
column with text descriptions and an adjoining column with code numbers for each description. I want to type in the first few letters of the description and have auto fill-in generate the remainder of the text, AND, the corresponding code number. This is my first post. Thanks very much - williamz |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
linking columns for auto fill-in
If you have a contiguous range of cells in the description column and
Autocomplete enabled, the first few letters typed should give you the choices. For the adjoining column fill-in you could use a VLOOKUP formula and a lookup table. Assumes each same description has the same code number. See help on VLOOKUP. Gord Dibben MS Excel MVP On Mon, 6 Oct 2008 07:14:06 -0700, williamz wrote: I'm very new at this - I want to simplify filling in a timesheet. I have one column with text descriptions and an adjoining column with code numbers for each description. I want to type in the first few letters of the description and have auto fill-in generate the remainder of the text, AND, the corresponding code number. This is my first post. Thanks very much - williamz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protecting and Auto fill Columns | Excel Worksheet Functions | |||
auto fill columns based on a selection | Excel Discussion (Misc queries) | |||
Auto fill Column based on data in other columns | New Users to Excel | |||
I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions | |||
Auto fill of columns | Excel Discussion (Misc queries) |