Reply to thread

Message: [QUOTE="vezerid, post: 3708092"] I assume you have a separate sheet for each fund. In your master sheet compile, in column A:A, the names of all the worksheets containing funds. Say you start from A2 to allow for headers. B2 will contain the shares and C2 the balance. In B2, C2: =LOOKUP(10^307,INDIRECT("'"&A2&"'!B:B")) =LOOKUP(10^307,INDIRECT("'"&A2&"'!E:E")) For the last one I am not sure which column you consider the be the balance, but change the column in the formula. HTH Kostis Vezerides [/QUOTE]