How do I post values from source workbook to destination workbook

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

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 [email protected]>
wrote in message news:[email protected]...
> 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