Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you link text from one worksheet to another?
Within a workbook I have multiple worksheets. I want them to all feed into a
dashboard within the workbook. The data is all text and a color-coded status column. I would like to link the text on the dashboard to the text in other worksheets if possible, so when I update one the other will automatically update. I am familiar with the linking of numerical values but have recently been approached with regards to the issue above. Is this possible, and if so how is it done? Thank you for all your help! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can you link text from one worksheet to another?
Text is linked the same way as numbers:
=Sheet1!A2 will return whatever is in cell A2 of sheet1. HTH, Bernie MS Excel MVP "KlipschPM" wrote in message ... Within a workbook I have multiple worksheets. I want them to all feed into a dashboard within the workbook. The data is all text and a color-coded status column. I would like to link the text on the dashboard to the text in other worksheets if possible, so when I update one the other will automatically update. I am familiar with the linking of numerical values but have recently been approached with regards to the issue above. Is this possible, and if so how is it done? Thank you for all your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I link the text in a cell into a comment box? | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
link worksheet A & B | Excel Worksheet Functions | |||
Finding Text To Copy To Another Worksheet | Excel Worksheet Functions | |||
How do link to a remote worksheet using the path value in a field? | Links and Linking in Excel |