Formula to Post from one Excel Doc to Another

  • Thread starter Thread starter Shiloh917
  • Start date Start date
S

Shiloh917

I need to take the values from one Excel document and have it feed thes
values into another Excel document. They are located in differen
places. How do I do this
 
Hi Shiloh917!

='[Test File 2003.xls]Budget 2003'!$A$1



Note the use of the single quotes. They are only essential if the
workbook or the sheet have spaces in their names. The workbook name
must be enclosed in the [ ] type parentheses.



Incidentally, the referenced workbook does not need to be open. In
that case you need to put the path to the workbook:



='C:\My Files\NewsGroups\Posting Testers\[Test File 2003.xls]Budget
2003'!$A$1



But the easiest way to get these references right is to use a point
and click and enter approach. Excel will then ‘build’ a correct
reference to the workbook and worksheet and cell. If you then close
the referenced workbook, you’ll note that the reference changes by
adding the path name as well.


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
I am opening both Excel Documents I go to the cell in the one doc tha
has the value I want. I go to the other document and click in the cel
where I want that value to fill into and it does nothing. I can cop
and paste into the doc but to test it I changed the value in the sourc
doc and it will not change in the doc that needs to update in tha
field. Can you break it down for me? I have put fomulas in from on
sheet to another but this is going from one doc to another this is ho
the file is named.

O:\Admin\ABG Totals\2003-2004 Lab Totals.xls
(This is the Source Doc)

then I want it to fill into cells in the Destination Doc:

O:\Admin\ABG Totals\CBJ Lab Tot Ped 2003.xls


What am I doing wrong
 
Hi Shiloh917!

With both documents open

In Destination document select the cell for the first entry
Press =
Now navigate to the source document
Select the cell you want to bring in
Press Enter

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Shiloh917!

You're welcome. But a few words of caution..

You might notice that as soon as you close the source workbook the
references to it change to include the path. This means that you can
very easily accidentally exceed the number of characters allowed for a
formula. Also, it will all end in tears if you change the name of the
Source workbook once it is closed or if you use Save As and start
working with the source workbook under a new name.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top