Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can a table be linked
It's been requested that a table in one worksheet be linked to the same table
in another worksheet. Can Excel update ALL information changed in the first table to the linked table without having to link each cell separately? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can a table be linked
No (and yes)
Each of the cells will have to be linked, but you don't have to do each one individually one-by one. Let's say your source table in WBook1 begins in cell A1 on some sheet in it, and the table in the other workbook, WBook2, begins at cell C1 (although it could also begin at A1, I'm using 2 different cells to help keep things clear). Go to C1 in WBook2 and type the = symbol then choose WBook1 the proper sheet and click in cell A1 and hit the [Enter] key. This sets up one link at the upper left corner of the tables. The formula in C1 probably looks something like: =[WBook1]Sheet1!$A$1 edit that formula to look like =[WBook1]Sheet1!A1 Notice that all I did was remove the $ symbols. Now you can move your cursor to the lower right corner of C1 until it turns into a small + symbol instead of the huge cross and drag it to the right and down (you may have to drag in one direction, then select all and drag in the other, i.e. right then down) until you've covered the same number of cells as are in your original table. Voila'! the table in WBook2 is now linked to the table in WBook1. "Linda" wrote: It's been requested that a table in one worksheet be linked to the same table in another worksheet. Can Excel update ALL information changed in the first table to the linked table without having to link each cell separately? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can a table be linked
Wouldn't Paste SpecialPaste Link do this all in one step?
i.e. select the range in sheet1 then paste specialpaste link to C1 in sheet2 Gord On Wed, 28 Oct 2009 06:43:01 -0700, JLatham wrote: No (and yes) Each of the cells will have to be linked, but you don't have to do each one individually one-by one. Let's say your source table in WBook1 begins in cell A1 on some sheet in it, and the table in the other workbook, WBook2, begins at cell C1 (although it could also begin at A1, I'm using 2 different cells to help keep things clear). Go to C1 in WBook2 and type the = symbol then choose WBook1 the proper sheet and click in cell A1 and hit the [Enter] key. This sets up one link at the upper left corner of the tables. The formula in C1 probably looks something like: =[WBook1]Sheet1!$A$1 edit that formula to look like =[WBook1]Sheet1!A1 Notice that all I did was remove the $ symbols. Now you can move your cursor to the lower right corner of C1 until it turns into a small + symbol instead of the huge cross and drag it to the right and down (you may have to drag in one direction, then select all and drag in the other, i.e. right then down) until you've covered the same number of cells as are in your original table. Voila'! the table in WBook2 is now linked to the table in WBook1. "Linda" wrote: It's been requested that a table in one worksheet be linked to the same table in another worksheet. Can Excel update ALL information changed in the first table to the linked table without having to link each cell separately? |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Can a table be linked
No doubt that it would! I just didn't think about that when I wrote my
response - low blood sugar, no doubt! Thanks for the reminder. "Gord Dibben" wrote: Wouldn't Paste SpecialPaste Link do this all in one step? i.e. select the range in sheet1 then paste specialpaste link to C1 in sheet2 Gord On Wed, 28 Oct 2009 06:43:01 -0700, JLatham wrote: No (and yes) Each of the cells will have to be linked, but you don't have to do each one individually one-by one. Let's say your source table in WBook1 begins in cell A1 on some sheet in it, and the table in the other workbook, WBook2, begins at cell C1 (although it could also begin at A1, I'm using 2 different cells to help keep things clear). Go to C1 in WBook2 and type the = symbol then choose WBook1 the proper sheet and click in cell A1 and hit the [Enter] key. This sets up one link at the upper left corner of the tables. The formula in C1 probably looks something like: =[WBook1]Sheet1!$A$1 edit that formula to look like =[WBook1]Sheet1!A1 Notice that all I did was remove the $ symbols. Now you can move your cursor to the lower right corner of C1 until it turns into a small + symbol instead of the huge cross and drag it to the right and down (you may have to drag in one direction, then select all and drag in the other, i.e. right then down) until you've covered the same number of cells as are in your original table. Voila'! the table in WBook2 is now linked to the table in WBook1. "Linda" wrote: It's been requested that a table in one worksheet be linked to the same table in another worksheet. Can Excel update ALL information changed in the first table to the linked table without having to link each cell separately? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table from linked spreadsheets | Excel Worksheet Functions | |||
linked 3 pivot table pages ????? | Excel Worksheet Functions | |||
automating external linked pivot table | Excel Discussion (Misc queries) | |||
Insert rows in linked table that are added to secondary table | Excel Discussion (Misc queries) | |||
Why does linked table open? | Excel Discussion (Misc queries) |