No, formulas produce results in the cell in which they are located. You
can't push information to another workbook or another location using
formulas.

--
Regards,
Tom Ogilvy

"Raghavendra Kulkarni" <Raghavendra
wrote in message ...
I have 2 workbooks, one having the source data which has to be posted in
specified cells in the destination workbook. I cannot put a link in the
destination workbook as the cells in the destination workbook accepts
restricted values such as y or n.
Can I put a link in the source workbook and post values from the source
workbook to the destination workbook ?

I also would like to post values without opening one/both workbooks.
Please
help me in the matter