inserting data in another file

As suggested, I"m re-posting this from the General forum:

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 spreadsheet is copied into a new job, whenever the spreadsheet is updated and closed, 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. As suggested, here's the root of the question:

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

Thanks for the help.

Johnny

Not possible, Excel wizards?

Johnny

Hello johnnytripod,

If you could give some short examples of what goes into what cell, it would help a great deal.

Thanks,
Leith Ross

OK, thanks. What I have is a template spreadsheet with job properties for cabinets. When a new job is started, this template is automatically copied into the job folder. A cell within this Job spreadsheet will have a value for base cabinet height. Let's say the default is 30". Now, what will ultimately control the height of the cabinets when they are put in an Autocad job is a cell in a different spreadsheet, called Setup. This file stays in the program folder, does not move, and is referenced by the Acad program when a new cabinet is put in the job. Here is what I'm trying to do: When I open up the Job spreadsheet in my new job, I want to enter a new value for the base height. Say, 40". When I close this spreadsheet, I want this new value to then be reflected in the correct cell in the Setup spreadsheet. Does this make sense? The new value needs to be inserted in the other spreadsheet.

Johnny