I have a document that has 2 worksheets. i want to pull
information from one to the other e.g. i want to pull the
first record that has "cdt" as a reference into a
specific cell on the read worksheet. If cdt is not in the
information worksheet then no record will be shown

Thanks

Nick