Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking Tables between sheets
I want my Excel file to have 2 sheets with 2 tables.
I want the 2nd Sheets Table to be LINKED to the 1st (so when I update the 1st, the 2nd auto-updates). Just FYI, Im planning to hide some rows/columns on the 2nd sheet, but still want it to be linked to & auto-updated from sheet 1s table. Is this possible in Excel? Bob. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking Tables between sheets
hi Bob,
yes it's possible, just put on the sheet2 =sheet1!range range = the source cell of sheet1 eg if you would like the cell a2 on sheet 2 shows the cell a2 on sheet 1 result =sheet1!a2 hide rows or columns will not have influence on the formulas hth regards from Brazil "BobD" escreveu: I want my Excel file to have 2 sheets with 2 tables. I want the 2nd Sheets Table to be LINKED to the 1st (so when I update the 1st, the 2nd auto-updates). Just FYI, Im planning to hide some rows/columns on the 2nd sheet, but still want it to be linked to & auto-updated from sheet 1s table. Is this possible in Excel? Bob. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Linking Tables between sheets
On Tue, 04 Jul 2006 15:49:02 +0100, Marcelo
wrote: hi Bob, yes it's possible, just put on the sheet2 =sheet1!range range = the source cell of sheet1 eg if you would like the cell a2 on sheet 2 shows the cell a2 on sheet 1 result =sheet1!a2 hide rows or columns will not have influence on the formulas hth regards from Brazil easy to type = into cell in 2nd sheet and then click on the required cell in the first sheet. Then drag the formula around sheet2 to copy the formula Steve "BobD" escreveu: I want my Excel file to have 2 sheets with 2 tables. I want the 2nd Sheets Table to be LINKED to the 1st (so when I update the 1st, the 2nd auto-updates). Just FYI, Im planning to hide some rows/columns on the 2nd sheet, but still want it to be linked to & auto-updated from sheet 1s table. Is this possible in Excel? Bob. -- Steve (3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
linking sheets | Excel Worksheet Functions | |||
Linking access tables, querys | Excel Discussion (Misc queries) | |||
Lookup Tables with linked sheets | Excel Discussion (Misc queries) | |||
Linking sheets | Excel Discussion (Misc queries) | |||
Linking 2 Excel Sheets, Anticipating Lines. | Excel Worksheet Functions |