Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Attributes
I work for a University in the state of Texas, and one of my
responsibilities is to manage the database for our vehicle fleet.We have over 200 vehicles in the fleet, so at the end of each month I generate approximately 1300 entries for our fuel consumption database and odometer readouts. I was wondering if there is a way to associate fuel type and vendor information with a unique 12 digit Equipment ID. For example: Vehicle 757000206446 always receives unleaded fuel from a commercial source. Vehicle 757000213220 always receives diesel fuel from a commercial source. Vehicle 757000213276 always receives diesel fuel from an internal source. So ideally what i would like, is to type in the ID and have the other two columns fill themselves in. So if Column 1 reads 757000206446 Then Column 2 reads Unleaded and Column 3 reads Commercial and so on. The Catch is that my worksheets have to get converted into .csv format in order to import the data into the database, so to the best of my knowledge equations will not work, as when a worksheet is exported into .csv format the text reads out as the equation, not the final answer. Any Suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Attributes
Hi Allan
You could have a 2 pronged approach to this. 1. Name Sheet.1 as Data Input. your 1st column could be converted to a Validated List and then you can populate your other 2 columns using a lookup table. example: =IF(I6="","",(LOOKUP(I6,INFO!$H$2:$L$132,INFO!$I$2 :$I$132))) 2. Name sheet.2 as Data Export After you have finished inputting the information, copy the range you require, then PasteSpecial.Values into here and export this into your .CSV File. Check out Debra Dalgliesh's website for some really good examples of Data Validations and lookups. http://www.contextures.com/xlDataVal08.html HTH Mick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ATTRIBUTES | Excel Discussion (Misc queries) | |||
Data value display attributes linked to table attributes | Charts and Charting in Excel | |||
File Attributes | Excel Programming | |||
File Attributes | Excel Discussion (Misc queries) | |||
Different text attributes... | Excel Programming |