> First thing I want to be able to do is have a spreadsheet or an OOo > database (which I have already created) with the telephone numbers > and the corresponding vessel name. Then I can query that table so > that in possibly a new spreadsheet it substitutes the phone number > with the vessel's name.
Hi Curtis First I've to say: that's database-stuff and should be done with database-function. But in this theme I can't help. So I 'll describe how I managed a simular situation only with calc-sheets: I get every month a logfile (CSV) to analyize. So I created a Calc-spreadsheet und linked the CSV-file as an own table of the spreadsheet that can always be actalized when opend (insert/sheet:From file + Link). The CSV-File (must not nesessarily be a CSV-file) gets every month overwritten, so that the spreadsheet allways links to the newest version. In a second sheet of the spreadsheet you could place a table with the phone-number and the vessel's name (and more information, if you like). The phone-number that will be used as a key has to stand in the first column. It would be helpfull to define this table as a range: Mark the whole sheet (so you do not need to change anything when you add new lines or columns), then: Menu:Data/define range: telephone In a third sheet you merge this information, for example: In column A you write: =Sheet1.A1, where Sheet1 is the linked monthly file and A1 the telephone-number. In column B you write: =VLOOKUP(A1;telephone;2;0) that gives you the vessel's name, when the name stands in row no. 2 of "telephone". For the rest of the columns, you take the ones you need. I suppose, the number of lines may be different from month to month. So create enough copies of the line you created in sheet no. 3. You might integrate an IF-formula so that the lines keep empty, when there are no more data-lines in the linked table. For to work with datapilot I'd mark the whole third sheet, it should be possible to filter the data-pilot-results so that empty lines where unaccounted. cheers, Claudia --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
