| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
point to a cell in another workbook
I have a workbook with several sheet in the book and one sheet that will need
to pul from one of the seperate sheet (same location, just different sheet). The normal forlmula is ='[sheetname]'!cell. Is there anyway that the sheet name can reference a data range so that all I have to do is change the value in the data range to update the formula? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
point to a cell in another workbook
Look for examples of INDIRECT to do this
Regards Trevor "pcox" wrote in message ... I have a workbook with several sheet in the book and one sheet that will need to pul from one of the seperate sheet (same location, just different sheet). The normal forlmula is ='[sheetname]'!cell. Is there anyway that the sheet name can reference a data range so that all I have to do is change the value in the data range to update the formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Display a digit before or after the decimal point in another cell | Excel Worksheet Functions | |||
| Linking a cell to another workbook cell based on a variable name | Excel Discussion (Misc queries) | |||
| linking cell value in one workbook to a cell in another workbook | Links and Linking in Excel | |||
Linear Mode
