no. sorry.
formulas return a value, they cannot perform an action
like copy.
it may be possible to use a macro to do that but without
seeing your data and knowing more about, i can only guess.
-----Original Message-----
in the IF function is there anyway that i can have
the 'if true' section of
the formula copy the values in another workbook in
specific rows. In other
words,
=IF(ISNA(MATCH($A5,[SDS.xls]NOW!$L$3,0)), IF TRUE then
copy cells n8:n12 and n14:n15 in workbook SDS to cell
b5:g5 in workbook wkly
mgt?
Brigida
.
|