cell linking to another workbook

C

chief

I have cell referencing right now in my workbook A for ex. In cell D4
have

=Sheet2!A25

I have been able to link data between sheets in the same workbook, bu
I would like to link cells from 2 different workbooks, is thi
possible
 
I

icestationzbra

unless you mean something more profound than i can understand, this is
short and sweet answer:

=[VIN.xls]Sheet1!$A$
 
C

chief

It did work, thanks alot. However, there is about 10,000 cells whic
have to have this formula in them. When I copy and paste this formul
into the cell below it, it comes up the same so I have to change it t
$A$4 for ex., and then I have to navigate through the network to fin
the file to link it to. This process will take forever to do, is ther
a way to fast track this method?

=[SEPTEMBER04.xls]Sheet1!$A$
 
I

icestationzbra

can you provide a synopsis of your question so that an idea can be got
about the background of what you are trying to do and what is the
layout of your file etc... anything that you think might help, would
help.
 
C

chief

I have an invoice program set up called INVOICE PROGRAM, and a
inventory program for the current month called SEPTEMBER04.
I am using excel 97. In the invoice program, there are color blankete
cells ranging from columns N1 to T1850. I had the original inventor
set up inside the invoice program in sheet2 but I am removing it an
making a seperate workbook due to user difficulties. Anyways
originally I had the invoice workbook's Sheet1 cell N4 for instance se
up as (=Sheet2!A5) for instance, that way when the user change
something in Sheet2 it would transfer automatically over into th
appropriate mirror cell in Sheet1. Now that I have moved tha
inventory into a seperate workbook, the new code I showed above work
but will take days to implement one by one. All I want is to have m
invoice program cells (N1:T1850) to be "linked" or reflective of th
appropriate cells in the inventory workbook
 
I

icestationzbra

try this method. use the same formula, but without the $'s.

=[SEPTEMBER04.xls]Sheet1!A3

now, since your data spans 7 columns and about 1900 rows, just dra
this formula that far and wide. without the $'s the absolut
referencing will be gone, and you should be able to avoid some manua
and menial work.

revert if that does not work. if not me, someone else should definitel
be able to help
 
Top