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

How do I post values from source workbook to destination workbook
 

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