View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TUNGANA KURMA RAJU
 
Posts: n/a
Default macro to extract data of a selected sheet

I have a w/book contains 120 sheets all contains similar data columns.I have
a anlysis sheet in which data analysis tools are placed in a1:m35.I am
looking for a macro to look sheetname(in a1 sheetnames list is placed) and
relevant data of that sheet be loaded to analysis sheet from N1 onwards.