Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links between cells in different workbooks/files
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links between cells in different workbooks/files
See help on "create a link"
Then select this category "Create a link to another cell, workbook, or program" Gord Dibben MS Excel MVP On Wed, 7 Feb 2007 12:28:01 -0800, GTifeld wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Links between cells in different workbooks/files
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. "Gord Dibben" wrote: See help on "create a link" Then select this category "Create a link to another cell, workbook, or program" Gord Dibben MS Excel MVP On Wed, 7 Feb 2007 12:28:01 -0800, GTifeld wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
Links in Cells | Excel Discussion (Misc queries) | |||
How to copy a row with transposing to a column retaining links to input cells? | Excel Worksheet Functions | |||
Maintain proper links when Excel cells are moved | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions |