| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel kept on asking to save file every time I jump from one sheet to another! | Excel Worksheet Functions | |||
| Copy and paste special - values into new excel file | Excel Discussion (Misc queries) | |||
| Lookup values in multipul sheets and show value in another sheet | Excel Worksheet Functions | |||
| "Delete sheet" not an available option on File menu. | Excel Worksheet Functions | |||
| Save only values of one sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
