how to solve this?
 

--------------------------------------------------------------------------------

Hi, can anyone out there please help me to solve this?

I have created many different excel workbooks (each with multipl
worksheets) which help me to analyse different scenarios. Thes
workbooks are linked in some way. (e.g. the input values in workbook
are linked to that in workbook 2, workbook 3 and so on. Sometimes th
output values of workbook 1 become the input values of certai
worksheets in workbook 2 etc). I find it tedious to keep track of al
these input and output values - which is linked to which.

So, I am thinking of creating one single sheet, where I can enter AL
my input values, instruct the respective workbooks to extract their ow
relevant data from this sheet and return ALL the output values on th
SAME sheet. Is it possible? How?

Thanks

--
jackoa
-----------------------------------------------------------------------
jackoat's Profile: http://www.excelforum.com/member.php...fo&userid=2580
View this thread: http://www.excelforum.com/showthread.php?threadid=52737