Links between cells in different workbooks/files

G

GTifeld

This is probably the easiest thing, but I can't find the answer using online
Help.

I simply want to setup cells in different worksheets or files where, if I
change a cell in one, it will automatically update in another. I'm talking
about straight data; Not formulas. Presently, they're different files
completely, but I can combine them into one file (different sheets) if that
will make it easier.

Any and all help is appreciated. Thank you in advance.
 
G

Gord Dibben

See help on "create a link"

Then select this category "Create a link to another cell, workbook, or program"


Gord Dibben MS Excel MVP
 
G

GTifeld

Hi Gord,

Thank you for your response, but I'm having a little difficulty following
your instructions. Where do I find this topic? I click on both "Help" and the
wizard, but don't find this literal topic. I've found variations on it, but
they don't answer my question. Can you direct me please? Thanks again.
 
Top