View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Anift
 
Posts: n/a
Default Retrieving values from a specified sheet of a different file.

Hi I have a file " daily Figures.xls " with 30 sheets with names as Mar-1 to
Mar-30 with some daily figures in fixed cells. Now on a different excel file
I have to retrieve figures for a particular date from the " daily Figures.xls
" by going to that Sheet which has name as date ( Mar -5). Is there any way
we can move to that file and move to a particluar sheet to retrieve values on
new file.

Any help will be appreciated!!