Thread: Create a macro which can find a record in three books
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sand sand is offline
external usenet poster
  
Posts: 21
Default Create a macro which can find a record in three books
i havent use VB or Macro codings ever, How can i create a macro which can
find a record in three workbooks ( more than ten sheets each workbook )
and show me result data of next cell i.e. if the record found in Daily
Tracker format.xls]RMM'!$BP$21 then result will be Daily Tracker
format.xls]RMM'!$BQ$21

Reply With QuoteReply With Quote