M
madiba
Hi,
I have two files (a master and a detail) in which I pull through a
column from the detail to the master, using "=[Detail.xls]Sheet1!$A$2"
However I would like to configure the spreadsheets so that only data
which meets a condition is pulled in the master, in other words using
pseudo code as follows.
If [link] in detail.xls = yes then display in master. I realise that
the condition statement will probably need to sit in the master file
but have no idea how this is done or whether possible at all.
Any ideas?
Mark
I have two files (a master and a detail) in which I pull through a
column from the detail to the master, using "=[Detail.xls]Sheet1!$A$2"
However I would like to configure the spreadsheets so that only data
which meets a condition is pulled in the master, in other words using
pseudo code as follows.
If [link] in detail.xls = yes then display in master. I realise that
the condition statement will probably need to sit in the master file
but have no idea how this is done or whether possible at all.
Any ideas?
Mark