Importing data question

O

opticalguy

I have a text document that contains unique job numbers, location of th
job, date and time last scanned, number of breakages, days in process
customer number etc. Several of the fields change multiple times durin
a day but job number is unique and would dissappear only once a job i
completed. I can figure out how to get external data into an exce
spreadsheet and how to refresh the data but my problem is I want to b
able to add comments/notes to each one (customer was called regardin
delay/part on back order/called customer on xx/xx/xx etc.) Each time
refresh data my notes are in the row but the job it was associated wit
has moved because of the addition/deletion of jobs.
How can I link my job number to my comments in a way that I want los
the link even if I resort or add/delete jobs when refreshing the data?
I can attach the text document if that would help.
Thanks
 
D

Dave Peterson

I think I would use another worksheet that contained the job number and the
comment (columns A:B).

And to make life simpler, I'd just use an additional column of cells in import
worksheet.

And just use =vlookup() when I wanted to retrieve the comment.

=IF(ISERROR(1/LEN(VLOOKUP(A1,sheet2!a:b,2,FALSE))),"",
VLOOKUP(A1,sheet2!a:b,2,FALSE))
(one cell)

If it's really important, you could have a macro that loops though the table and
creates a comment in the correct Job number cell.
 
Top