How to extract input data?
 

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

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

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

Thanks for your kind advice!

Regards

Jack


--
jackoat
------------------------------------------------------------------------
jackoat's Profile: http://www.excelforum.com/member.php...o&userid=25800
View this thread: http://www.excelforum.com/showthread...hreadid=526989