I am working on something like that too, to share with you I discovered
the function called vlookup & indirect is quite useful.

However, there are problem I can't solve with the above. This is how it
goes....

I have a summary workbook called "PartnerRawDataTracker.xls" and 3
other workbook namely "(200511) RawData.xls" & "(200512) RawData.xls" &
"(200601) RawData.xls" There are a lists of companies with number of
purchases in each. In my "PartnerRawDataTracker.xls" i used this
=INDIRECT("'[("&$B$2&") RawData.xls]"&$B$2&"'!A2"), which &$B$2&
equalvalent to 200601 in a column of the same sheet, which is
changable. Now when I change my year, I able to retrieve the data from
the specific workbook..... HOWEVER, In

=INDIRECT("'[("&$B$2&") RawData.xls]"&$B$2&"'!A2") it only points to
the same column"A2" of the 200601 workbook, I cannot copy & paste for
it to copy whole range of companies !!! How do I use the same formula
BUT with A2+1 incorporated ?

This method doesn't seem to solve the data expansion problem too, if i
have 5 companies now, in 200603 I might have 8 companies, how can i
expands?


Please share.
Thanks

KS


--
karsin
------------------------------------------------------------------------
karsin's Profile: http://www.excelforum.com/member.php...o&userid=30467
View this thread: http://www.excelforum.com/showthread...hreadid=500893