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? |
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 |
All times are GMT +1. The time now is 12:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com