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

  • Thread starter Thread starter Guest
  • Start date Start date
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..
 
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
 
stb said:
I want to link the totals of certain columns of several worksheets to a
summary worksheet in the same workbook....
Click to expand...

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!
 
stb said:
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!
Click to expand...
 
Start typing a formula by pressing "=", then navigate to the cell you want
to link to.

Or, you might be able to use a 3D reference using the SUM formula (see XL
help on 3d references for more detail)
 
emgee100 said:
Typing equals, clicking on Sheet 1 and clicking on Sheet 2 isn't working for
me. I get a '0' in the cell, rather than the text from Sheet 1. Seems like
the cell should be formatted differently, but I've tried all the options.
Help!
Click to expand...
 
Back
Top