View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jtaiariol jtaiariol is offline
external usenet poster
 
Posts: 7
Default search text in other workbooks

Hi,

I wonder if someone can help me out. I have various excel files of book
listings. I would like to have a spreadsheet that can search column B in all
workbooks for a specific book title, then tell me which workbook the book
title is in and the row number if possible. Also can it find duplicate names
as well, thanks in advance for your help. I would then do the same for the
author.

John T.