| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculating the name of a worksheet
is there a way to create a formula that changes the name of a sheet within
another formula. In other words, the following is a reference to an external workbook within an IF Function -- '[SDS.xls]we121'!$L$3. The sheet name we121 will change on a wkly basis by 7 days. I would like to have the formula automatically look at the worksheet that is we121+7 OR we128. Is it possible? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To Refresh Chart Data Without Calculating The Worksheet | Charts and Charting in Excel | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
| Calculating using data from another worksheet | Excel Worksheet Functions | |||
Threaded Mode
