Linking cells in a workbook

  • Thread starter Thread starter aet-inc
  • Start date Start date
A

aet-inc

Hi:

Can someone please explain to me how to do the following?: I have
sheets (Sheet1 & Sheet2) in the same workbook.
I want cell A1 of sheet1 to always show what is in cell A1 of sheet2
even if I later insert new rows above cell A1 of sheet2. Regardless o
how I manipulate Sheet2, I want the actual info that shows in cell A
of sheet2 to show in cell A1 of sheet1.

Thank you in advance to anyone that can help me in this matter
 
aet-inc.

Type this formula into A1 on Sheet1 to reference Sheet2!A1.

=INDIRECT("Sheet2!A1")

You should always reference the same cell.

Hope this helps.

Regards,
Kevin

aet-inc said:
Hi:

Can someone please explain to me how to do the following?: I have 2
sheets (Sheet1 & Sheet2) in the same workbook.
I want cell A1 of sheet1 to always show what is in cell A1 of sheet2,
even if I later insert new rows above cell A1 of sheet2. Regardless of
how I manipulate Sheet2, I want the actual info that shows in cell A1
of sheet2 to show in cell A1 of sheet1.

Thank you in advance to anyone that can help me in this matter!


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
aet-inc.,

Just reread your message.

If you mean you always ~want~ Sheet2!A1, no matter what, then the formula I
gave you before is correct.
Type this formula into A1 on Sheet1 to reference Sheet2!A1.

=INDIRECT("Sheet2!A1")

You should always reference the same cell.
Click to expand...


But if you want to follow Sheet2!A1 as it moves around because you had added
rows or columns, then I would suggest the following.

Steps:
1) Name Sheet2!A1 to "MyName" or whatever name you wish
a) Insert | Name | Define...MyName

2) In cell Sheet1!A1 write as a formula
a) =MyName

Now you can add rows or columns, and Sheet1!A1 will always refer to the
specific cell MyName regardless of how many row or columns you add. The
only exception is if you delete MyName.

Hope that helps.

Regards,
Kevin
 
Back
Top