View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chris Chris is offline
external usenet poster
 
Posts: 788
Default copy selected tabs from multiple workbooks to a new workbook

I want to compare a user text input to the name of a worksheet tab(A or B),
and if the user input matches A or B copy the corresponding tab to a new
workbook, in order to combine selections from 8 sources to one workbook