Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Linking a range of data from another sheet with its name in a cell
I have an excel spreadsheet that has a defined range of cells on SHEET2 called RANGE_NAME. On SHEET1 I have a cell that contains the text name of the range, or "RANGE_NAME". I am trying to figure out how to set up a formula to link RANGE_NAME on SHEET2 to location I have selected on SHEET1...- gwm
- Thread
- Replies: 1
- Forum: -Engineering spreadsheets
-
EXCEL CELL REFERENCES
I have a multi-page Excel worksheet in which I have references to cells on other sheets, e.g. ='SHEET2'A1. Is there a way to have the "SHEET2" page reference point to a cell instead with the cell contents having the page I wish the reference to point to. In other words, the formula...- gwm
- Thread
- Replies: 2
- Forum: -Engineering spreadsheets
