| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link an incrementing file name like reports1or reports2
=SUM('C:\F drive\My Documents\Expense reports\[Lkreport47.xls]Mileage Log and
Reimbursement'!J5) I want to increment the file name to the latest one which is always ending in a higher numerical. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I link an incrementing file name like reports1or reports2
Try
=INDIRECT("'C:\F drive\My Documents\Expense reports\[Lkreport" & ROW(A46)+1 & ".xls]Mileage Log and Reimbursement'!J5") If this post helps click Yes --------------- Jacob Skaria "gonzerv" wrote: =SUM('C:\F drive\My Documents\Expense reports\[Lkreport47.xls]Mileage Log and Reimbursement'!J5) I want to increment the file name to the latest one which is always ending in a higher numerical. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I link an incrementing file name like reports1or reports2
NB...
The source file must be open for INDIRECT to work properly. So, if you copy the formula down 10 cells representing links to 10 different files then all 10 of those files have to be open. This is usually not desirable (read: practical). -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Try =INDIRECT("'C:\F drive\My Documents\Expense reports\[Lkreport" & ROW(A46)+1 & ".xls]Mileage Log and Reimbursement'!J5") If this post helps click Yes --------------- Jacob Skaria "gonzerv" wrote: =SUM('C:\F drive\My Documents\Expense reports\[Lkreport47.xls]Mileage Log and Reimbursement'!J5) I want to increment the file name to the latest one which is always ending in a higher numerical. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I link an incrementing file name like reports1or reports2
P.S.
Also, since the files must be open then you don't need to include the path in the formula. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... NB... The source file must be open for INDIRECT to work properly. So, if you copy the formula down 10 cells representing links to 10 different files then all 10 of those files have to be open. This is usually not desirable (read: practical). -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Try =INDIRECT("'C:\F drive\My Documents\Expense reports\[Lkreport" & ROW(A46)+1 & ".xls]Mileage Log and Reimbursement'!J5") If this post helps click Yes --------------- Jacob Skaria "gonzerv" wrote: =SUM('C:\F drive\My Documents\Expense reports\[Lkreport47.xls]Mileage Log and Reimbursement'!J5) I want to increment the file name to the latest one which is always ending in a higher numerical. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I link an incrementing file name like reports1or report
Thanks Biff. I was only looking at incrementing part as the subject prompted
so... =indirect() function returns an error if the workbook is closed. Check out the below link for an addin =indirect.ext() which will help. http://xcell05.free.fr/ http://xcell05.free.fr/morefunc/english/index.htm If this post helps click Yes --------------- Jacob Skaria "T. Valko" wrote: P.S. Also, since the files must be open then you don't need to include the path in the formula. -- Biff Microsoft Excel MVP "T. Valko" wrote in message ... NB... The source file must be open for INDIRECT to work properly. So, if you copy the formula down 10 cells representing links to 10 different files then all 10 of those files have to be open. This is usually not desirable (read: practical). -- Biff Microsoft Excel MVP "Jacob Skaria" wrote in message ... Try =INDIRECT("'C:\F drive\My Documents\Expense reports\[Lkreport" & ROW(A46)+1 & ".xls]Mileage Log and Reimbursement'!J5") If this post helps click Yes --------------- Jacob Skaria "gonzerv" wrote: =SUM('C:\F drive\My Documents\Expense reports\[Lkreport47.xls]Mileage Log and Reimbursement'!J5) I want to increment the file name to the latest one which is always ending in a higher numerical. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link from Chart File to Data File / Format Problem | Charts and Charting in Excel | |||
| Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
| Excel file link with word file | Excel Worksheet Functions | |||
| xls spool file doesn't automatically link to new xls file | Excel Discussion (Misc queries) | |||
| Link footer of one file to cells in another file | Excel Discussion (Misc queries) | |||
Hybrid Mode
