Thank you for your solution
before trying it(I am not an expert),could you tell me if it is no
possible to use instead the CONSOLIDATE function?

In the EXCEL FUNCTION REFERENCE booklet of the early '90, I read th
following example:
=consolidate(("c:\excel\sales!r10:c1:r25:c6","c:\e xcel\saleswes!r10:c1:r25:c6"),9,true,true)

How can I tell excel that IN MY CASE, sales! is the content in cell A
,and saleswes! is the content in cell A2?

If your patience is not exhausted,please address this last question

--
tommasopalazzo
-----------------------------------------------------------------------
tommasopalazzot's Profile: http://www.excelforum.com/member.php...fo&userid=2773
View this thread: http://www.excelforum.com/showthread.php?threadid=48252