inserting data in another file

[johnnytripod]

I'd like to insert the value of a cell in Excel worksheet A into the cell of another Excel workbook B. The twist is that the source file begins as a templated file and is copied into new jobs each time. The destination file location and name stays the same but the source file changes location. So the destination file can't be looking to be updated. What needs to happen is that once the source Excel file is copied into a new job, whenever the cell is updated, it needs to "export" the new value into the source file. Not the other way around as the destination file will not know the location of this new source file. Sorry for the confusing syntax but hope this is clear enough for an answer. Thanks.

Johnny

[Bryan Hessey]

I'd like to insert the value of a cell in Excel worksheet A into the cell of another Excel workbook B. The twist is that the source file begins as a templated file and is copied into new jobs each time. The destination file location and name stays the same but the source file changes location. So the destination file can't be looking to be updated. What needs to happen is that once the source Excel file is copied into a new job, whenever the cell is updated, it needs to "export" the new value into the source file. Not the other way around as the destination file will not know the location of this new source file. Sorry for the confusing syntax but hope this is clear enough for an answer. Thanks.

Johnny

Hi,

for this you will need either a macro or an event trigger (that is, you will run the update when you need to, or, the update will run automatically, asin when the book closes etc).

As VB code will be involved you should re-ask your question in the Programming section, and so as to maximise your chances of an answer ask something like:

How do I automatically, on closing this workbook, update cell D24 into file C:\MyFiles\Excel\FormerFile.xls Sheet1 cell B27


hth
---

[johnnytripod]

Thanks. I have re-posted the question in the Programming forum.

Johnny

[Bryan Hessey]

Thanks. I have re-posted the question in the Programming forum.

Johnny

good to see, let's hope that you get a quick response.

---