How do I link cells from one excel worksheet to another?

David - I have done this and I get a "0" in the cell. Not sure why the cell
is not transferring. It shows me the equal sign followed by the name of the
sheet followed by and ! followed by the cell designation on the sheet where I
want to transfer the information but the end result is a "0". thanks - LL

"LL" wrote:

> Does the linking process have to contain numbers and formulas or can it
> contain words and symbols. I want to be able to update e-mail addresses in
> one location and have the change cross over to other sheets in the same
> workbook. thanks LL
>
> "David Billigmeier" wrote:
>
> > Type an equals sign in the cell you want the information to end up in, click
> > over to another worksheet, and click on the cell you want to reference.
> > Excel will automatically enter it in.
> >
> > --
> > Regards,
> > Dave
> >
> >
> > "stb" wrote:
> >
> > > I want to link the totals of certain columns of several worksheets to a
> > > summary worksheet in the same workbook. I keep seperate worksheets of the
> > > circulation stats of my library branches, and I want the totals of my columns
> > > to automatically show up on the cumulative worksheet as I enter new circ
> > > figures for each month in the year. Everything I've looked up talks about
> > > linking to different types of Office programs, not something as simple (but
> > > apparently hard to do) as this. Any help greatly appreciated!

If there is no data in the source cell a zero will display when

=Sheet1!A1 is used.

To trap for this

=IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP

On Mon, 31 Aug 2009 14:23:02 -0700, LL <LL DeleteThis @discussions.microsoft.com> wrote:

>David - I have done this and I get a "0" in the cell. Not sure why the cell
>is not transferring. It shows me the equal sign followed by the name of the
>sheet followed by and ! followed by the cell designation on the sheet where I
>want to transfer the information but the end result is a "0". thanks - LL
>
>"LL" wrote:
>
>> Does the linking process have to contain numbers and formulas or can it
>> contain words and symbols. I want to be able to update e-mail addresses in
>> one location and have the change cross over to other sheets in the same
>> workbook. thanks LL
>>
>> "David Billigmeier" wrote:
>>
>> > Type an equals sign in the cell you want the information to end up in, click
>> > over to another worksheet, and click on the cell you want to reference.
>> > Excel will automatically enter it in.
>> >
>> > --
>> > Regards,
>> > Dave
>> >
>> >
>> > "stb" wrote:
>> >
>> > > I want to link the totals of certain columns of several worksheets to a
>> > > summary worksheet in the same workbook. I keep seperate worksheets of the
>> > > circulation stats of my library branches, and I want the totals of my columns
>> > > to automatically show up on the cumulative worksheet as I enter new circ
>> > > figures for each month in the year. Everything I've looked up talks about
>> > > linking to different types of Office programs, not something as simple (but
>> > > apparently hard to do) as this. Any help greatly appreciated!

If you want to copy a cell entry from one worksheet into another worksheet
and have that 2nd worksheet change automatically when you change the data in
the cell in the first worksheet , here's how:
1) In the first worksheet, right click in the cell you want to copy and
click "copy"
2) Go to the cell in the 2nd worksheet that you want to enter the same
data,right click in that cell and click "paste"
3) After you paste it, a little box will appear on the bottom right of the
cell (looks like a folder/envelope). Click on that and a dropdown box will
appear. Click on "Link cells" if the cell you're copying doesn't have a
formula associated with it, or click on "Values and number formatting" if the
cell your copying has a formula in it (or click on any other item that
applies)
4) You're done. Now if you change the value in the original worksheet, it
will change in the 2nd worksheet automatically..


"stb" wrote:

> I want to link the totals of certain columns of several worksheets to a
> summary worksheet in the same workbook. I keep seperate worksheets of the
> circulation stats of my library branches, and I want the totals of my columns
> to automatically show up on the cumulative worksheet as I enter new circ
> figures for each month in the year. Everything I've looked up talks about
> linking to different types of Office programs, not something as simple (but
> apparently hard to do) as this. Any help greatly appreciated!

How do you / or is there a way to link cells from one Excell file to another
file? I have a large file with lots of data on a spreadsheet and I was
wanting to create a new file that would be a quick look at a summary from the
large file. Thanks

I had to "enter" to make the information show on target sheet in workbook!

"David Billigmeier" wrote:

> Type an equals sign in the cell you want the information to end up in, click
> over to another worksheet, and click on the cell you want to reference.
> Excel will automatically enter it in.
>
> --
> Regards,
> Dave
>
>
> "stb" wrote:
>
> > I want to link the totals of certain columns of several worksheets to a
> > summary worksheet in the same workbook. I keep seperate worksheets of the
> > circulation stats of my library branches, and I want the totals of my columns
> > to automatically show up on the cumulative worksheet as I enter new circ
> > figures for each month in the year. Everything I've looked up talks about
> > linking to different types of Office programs, not something as simple (but
> > apparently hard to do) as this. Any help greatly appreciated!

"stb" wrote:

> I want to link the totals of certain columns of several worksheets to a
> summary worksheet in the same workbook....

Here is a slightly more complicated version of this question (Excel 2007):

I have many copies of the same .xlsx worksheet with different text values on
Sheet1 of the form, and I anticipate getting many more. I would like to
create a summary sheet for all of these forms by specifying the NAME of the
..xlsx file in a cell and populate the cell information from specific cells
out of that file for each row in the summary worksheet. I thought that
perhaps I could specify the cell in the formula bar to dynamically update
based on the name of the file such as this:

=[D2]Sheet1!$B$6

where cell D2 in the destination workbook contains the file name text I
would like to pull from. As I add new files to my list I could then just add
the file name to the bottom of the list (in column "D") and the relevant info
would be populated in the other columns of the workbook...

Apparently this approach doesn't work due to the way the links are defined.
Is there any way to dynamically setup a link to files so I can just add the
file name to the workbook and have it pull out the needed info?

thx!