| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i update links in destination workbook when source workbo. | Excel Worksheet Functions | |||
| Excel-how to link source workbook to copy of destination workbook | Excel Worksheet Functions | |||
| Paste names from a source workbook to a destination | Excel Discussion (Misc queries) | |||
| updating destination when I add a line to my source workbook | Excel Worksheet Functions | |||
| how to copy succeeding rows from source workbook to destination w. | Excel Programming | |||
Linear Mode
