H
Hyperlinking Spreadsheets
the content automatically update?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How can I make spreadsheet content link to another sheet and have.
G
Gord Dibben
See help on "linking"
Basics.............on sheet2 enter =sheet1!A1
Copy across and down.
OR.......select a range on sheet1 and copy.
Switch to sheet2, select a cell and Edit>Paste Special>Paste Link>OK>Esc.
Gord Dibben MS Excel MVP
On Thu, 28 Aug 2008 07:31:01 -0700, Hyperlinking Spreadsheets <Hyperlinking
Basics.............on sheet2 enter =sheet1!A1
Copy across and down.
OR.......select a range on sheet1 and copy.
Switch to sheet2, select a cell and Edit>Paste Special>Paste Link>OK>Esc.
Gord Dibben MS Excel MVP
On Thu, 28 Aug 2008 07:31:01 -0700, Hyperlinking Spreadsheets <Hyperlinking
P
Pete_UK
Use this large white space to explain your problem more fully.
You would generally use a formula like:
=IF(Sheet1!A1="","",Sheet1!A1)
to bring the contents from A1 of Sheet1 to another cell, but there are
other ways which might be more suitable, depending on your exact
requirements. For example, if the cell with the formula is to be
dependent on another cell, then you might use one of the LOOKUP
functions, or an INDEX/MATCH combination.
Please describe what you want to achieve in more detail.
Hope this helps.
Pete
You would generally use a formula like:
=IF(Sheet1!A1="","",Sheet1!A1)
to bring the contents from A1 of Sheet1 to another cell, but there are
other ways which might be more suitable, depending on your exact
requirements. For example, if the cell with the formula is to be
dependent on another cell, then you might use one of the LOOKUP
functions, or an INDEX/MATCH combination.
Please describe what you want to achieve in more detail.
Hope this helps.
Pete
S
supoch14
Hyperlinking Spreadsheets said:the content automatically update?
S
supoch14
Gord Dibben said:See help on "linking"
Basics.............on sheet2 enter =sheet1!A1
Copy across and down.
OR.......select a range on sheet1 and copy.
Switch to sheet2, select a cell and Edit>Paste Special>Paste Link>OK>Esc.
Gord Dibben MS Excel MVP
On Thu, 28 Aug 2008 07:31:01 -0700, Hyperlinking Spreadsheets <Hyperlinking
S
supoch14
Pete_UK said:Use this large white space to explain your problem more fully.
You would generally use a formula like:
=IF(Sheet1!A1="","",Sheet1!A1)
to bring the contents from A1 of Sheet1 to another cell, but there are
other ways which might be more suitable, depending on your exact
requirements. For example, if the cell with the formula is to be
dependent on another cell, then you might use one of the LOOKUP
functions, or an INDEX/MATCH combination.
Please describe what you want to achieve in more detail.
Hope this helps.
Pete
S
supoch14
Gord Dibben said:See help on "linking"
Basics.............on sheet2 enter =sheet1!A1
Copy across and down.
OR.......select a range on sheet1 and copy.
Switch to sheet2, select a cell and Edit>Paste Special>Paste Link>OK>Esc.
Gord Dibben MS Excel MVP
On Thu, 28 Aug 2008 07:31:01 -0700, Hyperlinking Spreadsheets <Hyperlinking