Linking Tables between sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want my Excel file to have 2 sheets with 2 tables.

I want the 2nd Sheet’s Table to be LINKED to the 1st (so when I update the
1st, the 2nd auto-updates).

Just FYI, I’m planning to hide some rows/columns on the 2nd sheet, but still
want it to be linked to & auto-updated from sheet 1’s table.

Is this possible in Excel?

Bob.
 
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:
 
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
Click to expand...


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
 
Back
Top