How do I post values from source workbook to destination workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA code for pasting links -- modifying RDB code for summary workbook 10
error trying to sort data 4
Copy Autofilter Source Workbook A result in Destination Workbook BSheet1 1
Copying cells and formula from closed workbook to all sheets in open workbook 0
merge data macro 4
Combine three InputBoxes into one? 7
Copy from One Workbook to Another 9
first sip of working with range in vba excel 6

Back
Top