Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on indirect()
I am trying to extract from closed workbook (diff books saved on daily basis)
file is in the path: 'C:\D Backup\HQCOLN\SGP REPORTS\CFO\MISC\COLLECTION REPORT\COLNDATA\ file name : cms0111.xls data in : sheet1 cell to refer : F2 I am keeping the path at B1 file name & rowno to refer at b4 & c4 - in b4 "cms0111" and in c4 value 2 now formula at : d4 =INDIRECT(TRIM($B$1&"["&B4&".XLS]Sheet1'!F"&C4)) I would be copying this formula down the rows to get row data from remote file I would be copying this formula sideways for column data (ofcourse I will change column ref "F" to "M", "V" and other columns as required. the below formula gives error "REF" =INDIRECT(TRIM($B$1&"["&B4&".XLS]Sheet1'!F"&C4)) any suggestion please and advance thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help on indirect()
Hi
INDIRECT works only with opened source file. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Eddy Stan" wrote in message ... I am trying to extract from closed workbook (diff books saved on daily basis) file is in the path: 'C:\D Backup\HQCOLN\SGP REPORTS\CFO\MISC\COLLECTION REPORT\COLNDATA\ file name : cms0111.xls data in : sheet1 cell to refer : F2 I am keeping the path at B1 file name & rowno to refer at b4 & c4 - in b4 "cms0111" and in c4 value 2 now formula at : d4 =INDIRECT(TRIM($B$1&"["&B4&".XLS]Sheet1'!F"&C4)) I would be copying this formula down the rows to get row data from remote file I would be copying this formula sideways for column data (ofcourse I will change column ref "F" to "M", "V" and other columns as required. the below formula gives error "REF" =INDIRECT(TRIM($B$1&"["&B4&".XLS]Sheet1'!F"&C4)) any suggestion please and advance thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT - Strange behavior | Excel Discussion (Misc queries) | |||
Indirect Range Referencing | Charts and Charting in Excel | |||
Copying a formulae down a column that includes an INDIRECT | Excel Discussion (Misc queries) | |||
Using the Indirect function with a sheet number instead of a sheet name | Excel Worksheet Functions | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions |