Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: gwm
  • Content: Threads
  • Order by date
  1. gwm

    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...
  2. gwm

    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...

Part and Inventory Search

Back
Top Bottom