| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert data automatically
I am trying to search this database to see if a customer is already in there
while entering a new row of information. If I enter another Arrow plastics under customer for instance, I would like the sales person to be entered in that column automaticallly. Can anyone help? I've tried vlookup but this dont work. In the example below: the sales person for Arrow plasics have already been entered. The next time I put in data for Arrow plastics I want the sales person (Joe Little) automatically. Asset # Date Location Sales Person Customer x 70000 October 25, 2005 Customer Joe Little Arrow Plastics x 70001 October 25, 2005 Customer Arrow Plastics x 70002 October 25, 2005 SHOP x 70003 October 26, 2006 Customer Bay Valley x 70004 October 26, 2006 Customer Bay Valley x 70005 October 27, 2006 Customer Vesuvius x 70006 October 27, 2006 Customer Vesuvius |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically insert time in excel but not automatically updated | Excel Worksheet Functions | |||
| automatically insert a row | Excel Worksheet Functions | |||
| How do I automatically insert a blank row between sets of data? | Excel Discussion (Misc queries) | |||
| Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions | |||
| Automatically insert fill colour when data is added? | Excel Worksheet Functions | |||
Linear Mode
