Then, you can use the name CustID in your formula, and, you can use it without a row reference since Excel will default to referencing the cell within the range that lies on the same row as the formula I've uploaded an updated version that demonstrates this technique for reference The download is RetrieveTableData2 Hope it helps!Module, and paste the following macro in the Module WindowReference cells in another Excel worksheet based on cell value I will show two examples here Example 1 Select a single cell and refer a whole range of cells I have two Excel worksheets with names BATBC and GP You can have many Both worksheets have similar kinds of data Profit (PCO), EPS and Growth of two companies for the last 5 years What I want is in the
Excel Formula Sheet Name From Cell