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