linking excel docs
 

I have linked 3 excel docs which have about 90% similar formatting and
formulas. in these docs i have a list of questions which differ slightly and
I would like to have columns with similar question to input in all three
excel docs. e.g question 1 in all three docs is the same, question 2 is
different across them. if answer in question 1 doc 1 is genius to have an
automatic input in doc 2 and doc 3.

Any suggestions on this (please note that these columns have an existing
formula),

thanx

linking excel docs
 

If I really understood your problem, you can add in your answear column of
doc2 and doc3 something like this:

=IF(OR(A2="",A2=0),"",IF(ISNA(VLOOKUP(A2,doc1_colu mn_A,1,0)),"",VLOOKUP(A2,doc1_column_A,1,0)))

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.


Thanks in advance for your feedback.


Ciao


Franz Verga from Italy (now in Berlin)GENO wrote:
I have linked 3 excel docs which have about 90% similar formatting and
formulas. in these docs i have a list of questions which differ
slightly and I would like to have columns with similar question to
input in all three excel docs. e.g question 1 in all three docs is
the same, question 2 is different across them. if answer in question
1 doc 1 is genius to have an automatic input in doc 2 and doc 3.

Any suggestions on this (please note that these columns have an
existing formula),

thanx