| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sheet Name Changes how do i code for that
=IF(ISERROR(INDEX([OrderGuideDBS.xls]COG!$A$1:$D$377,MATCH(B4,[OrderGuideDBS.xls]COG!$B$1:$B$377,0),3)),"",INDEX([OrderGuideDBS.xls]COG!$A$1:$D$377,MATCH(B4,[OrderGuideDBS.xls]COG!$B$1:$B$377,0),3))
Ok here is my formula and my problem OrderGuideDBS.xls is the file name always the same COG name of the sheet that i forgot was going to change i do not know what it is going to change to untill i upload the new sheet. How can i change the about formula to seach the file and bring back the new sheets name so my code will work Thank you all for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sheet names code | Excel Discussion (Misc queries) | |||
| VB code to copy sheet format to another sheet | Excel Discussion (Misc queries) | |||
| VBA code to identify last row in a sheet | Excel Discussion (Misc queries) | |||
| Code to protect sheet | Excel Worksheet Functions | |||
| Sheet Protection and VBA Code | Excel Discussion (Misc queries) | |||
Hybrid Mode
