Separate the sheet name from the location. Select the names. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. You can always ask an expert in the Excel Tech Communityor get support in the Answers community. If you dont want to use the above methods to reference a cell value as a sheet name, then you can simply type the sheet name or manually select it to get the values from that sheet easily. See screenshot: 3. We have different sheets named according to the Salesmen. When it attempted to run the Macro, an error message came up "Argument no optional". In other words, a formula that uses the sheet name in a way that can be changed by referring to up a value on the worksheet. Both approaches are explained below. This way I wouldnt have to do a replace (as I do now) for all values from the old tab name to the new tab name when Im cloning a worksheet. View the full answer. I want each of the entered exercise to display the lowest and the highest values of the weight that it can find in exercise logs on all the "Week xx . Why do we kill some animals but not others? Select a name from the Name Box to go to the range's location, or use the Named Range in a formula. You must have JavaScript enabled to use this form. 1. Here, January is the sheet name and D11 is the total sales value in that sheet. Add 1 with the previous result. YurHucklebarry End Sub. 3. How do I reference a sheet name in my SUMPRODUCT Formula in MS Excel? We want MID to start extracting text after the "]" character, so we use the FIND function to get the position, then add 1: The result from the above snippet is returned to the MID function asstart_num. Each of the month sheets has the same structure, which looks like this: The formulas on the summary tab lookup and extract data from the month tabs, by creating a dynamic reference to the sheet name for each month, where the names for each sheet are the month names in row 4. Before that, we will form a table that consists of the months name and serial number. Nesting Vlookup into IF and IFERROR Functions 7. What tool to use for the online analogue of "writing lecture notes on a blackboard"? I earn a small commission if you buy any products using my affiliate links to Amazon. I have completed BSc in Naval Architecture and Marine Engineering From Bangladesh University of Engineering and Technology (BUET). ='the red fox'!$a$1 Please do it by yourself. With VBA Code Important Notes Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. You want to make an Excel sheet, where the dates of the Excel sheet will change according to the sheet name. If you save the workbook, the macro will be saved with it. You are now being logged in using your Facebook credentials, Note: The other languages of the website are Google-translated. Enter the names of the sheets (such as 1 2 and 3) in cells in this column. Thanks so much. SheetR will store the cell values with sheet names in the VBA sheet. For example, sheet1 will be equal to its cell A1s value, and sheet2 will also be equal to its cell A1s value. Then, you will be taken to the March sheet, and from here select the cell D11. Press ENTER. For this example, let's assume the REAL name is 'Sheet1'. Here we will name the sheet as the name of the salesman in cell B5. I'm using your exact code from the above for VBA code which works perfectly for what I need. Click on the March sheet. Step 3: Now, in the output Cell C5, type the following formula: Set cell value equal to current tab name with formula, Set cell value / header / footer equal to current tab name with Kutools for Excel, Set cell values equal to all sheet names with Kutools for Excel. We will insert dates in the Date column based on the Sheet Name. Click in the Name box on the left hand side of the formula bar. I think we're real close. Each video comes with its own practice worksheet. If you have any suggestions or questions, feel free to share them in the comment section. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Applying IF Function 2. Why am I seeing the Name Conflict dialog box in Excel? That way if I add tabs I can easily update all the formulas. You can rename a worksheet in real time the moment you change a cell's value. It will extract the name of the Sheet which is a month name. The ISNUMBER () checks if a match is found by checking if the MATCH () fucntion returned a number. Andy provides this example where the sheet is different for every row, but he doesn't want to change the formula manually. Is there a way to change the macro to automatically update the tab, or will I need to press F2 each time? In Excel, how could you set a cell value equal to the current tab name, when the sheet name changes and the cell value will be changed as well? Excel MATCH Function Not Working, SUMIFS to SUM Values in Date Range in Excel, Formula for Number of Days Between Two Dates, Therefore, in a similar way, you can get the value for the sheet named , Firstly, right-click on the sheet name from the, After that, the sheet name will be changed to the cell value of. Otherwise, use the MID and FIND functions as explained below. If you want to have a free trial (30-day) of this utility, please click to download it, and then go to apply the operation according above steps. Your email address is private and not shared. Your website has been a HUGE help! In the example shown, the formula in C6 is: Note: The point of INDIRECT hereis to build a formula where the sheet name is a dynamic variable. Auto naming tab based on cell value. . Name your sheet tab same as cell value. The INDIRECT then this text into a normal reference and returns the value in cell C9, which is "Peach". VBA code: Make sheet tab equal to cell value. You can change it as you need. crystal: Is the whole code shown in your reply? 5 Easy Ways to Create Dynamic Named Range Based On Cell Value in Excel 1. Column 2 will supply me the name of the client. The Name Box in Excel is fastest way to create a named range: Select a cell or a range of cells that you want to name. Hope you will find it useful. You can apply the following formula to match the cell value with sheet tab name in Excel. 10/4/2019) and K2 being an ending date (eg, 10/10/2019) so resulting value is "Oct 4 - Oct 10" which is what I want the tab named. Use names in formulas Select a cell and enter a formula. Learn Excel with high quality video training. en suite rooms to rent bolton Sometimes you want to link to a form and prefill values based on the current row. In this section, we introduce you the Rename Multiple Worksheets utility of Kutools for Excel. You must have JavaScript enabled to use this form. Each of these examples use the formula =SUM(Sheet2:Sheet6!A2:A5) to add cells A2 through A5 on worksheets 2 through 6:. 3. Then, we have assigned the sheets January, February, and March to the variable ws1. Use the Indirect() so in some cell like A1 you would put The red fox then you would use: Now this is not "draggable" as in when it is dragged down the firs $A1 will change with the rows but the last A1 will not as it is in the Quotes. This thread is locked. Was Galileo expecting to see so many stars? 1). Partial solution. You can then create, edit, delete, and find all the names used in the workbook. 3 Ways to Use Cell Value as Worksheet Name in Formula Reference in Excel Method-1: Using INDIRECT Function to Use Cell Value as Worksheet Name in Formula Reference Method-2: Using INDIRECT and ADDRESS Functions to Use Cell Value as Worksheet Name Method-3: Using VBA Code to Use Cell Value as Worksheet Name in Formula Reference If you have any confusion please leave a comment, so Ill try my best to remove your confusion. June 10, 2020, by What I want to do is, using a formula, determine that the first columnar reference is to 'the red fox', and use that to drive all other references for that row. Since we are only interested in the name of the worksheet, we can modify this formula with the =MID function to retrieve only that portion of the file path. Hello,You are welcome. Delimiteris set to "]" in order to retrieve only text that occurs after the closing square bracket ("]"). I want to have a collective list of all workouts on a separate sheet, which is the tab "Exercises". Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range), Still issue is the same, it changes first time. 2.In the define names group, tab click the Define names option. Our goal is to help you work faster in Excel. 1 Answer. document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); ExcelDemy is a place where you can learn Excel, and get solutions to your Excel & Excel VBA-related problems, Data Analysis with Excel, etc. A Worksheet_Change event can look at the entry, evaluate it for worthiness, and immediately rename the worksheet tab to be the same as what you entered in the cell. I have this formula in C5 "=CONCATENATE(TEXT($K$1,"mmm")," ",TEXT($K$1,"dd")," - ",TEXT($K$2,"mmm")," ",TEXT($K$2,"dd"))" - K1 being a beginning date (eg. We provide tips, how to guide, provide online training, and also provide Excel solutions to your business problems. The formula in cell C5 is: = VLOOKUP ($B5, INDIRECT ("'" & C$4 & "'!" & "B5:C11"),2,0) Inside VLOOKUP, the lookup value is entered as the mixed reference $B5, with the column locked to allow copying across the table. In Excel 365, the easiest option is to use the TEXTAFTER function with the CELL function like this: = TEXTAFTER ( CELL ("filename",A1),"]") The CELL function returns the full path to the current workbook as explained above, and this text string is delivered to TEXTAFTER as the text argument. Ackermann Function without Recursion or Stack. Search row, create formula below found "search" name in header, copy formula down to last row, How to add the cell reference (not value) from "last sheet" to the summary sheet formula when "last sheet" changes every month, Torsion-free virtually free-by-cyclic groups, Sci fi book about a character with an implant/enhanced capabilities who was hired to assassinate a member of elite society. Creating the Drop Down Filter. Make sheet tab name equal to cell value with Kutools for Excel The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails. February 15, 2022, by and the tab name is 'Shmoe'. The formula in cell C5 is: Inside VLOOKUP, thelookup value is entered as the mixed reference $B5, with the column locked to allow copying across the table. There are 3 important considerations: Is there a way to only permit open-source mods for my video game to stop plagiarism or at least enforce proper attribution? Its a great pleasure that you are watching our articles. Read the below steps to get your solution. Step 1: Right click the worksheet in the Sheet Tab that you will dynamically name it by a cell value, and select View Code from the right-clicking menu. 1) Highlight and double-click on the worksheet Sheet1 (Shmoe) in the Project. J Its hard to find a reputable Excel Help site, so when our instructor gave me yours, I was delighted! Enter SheetName and press Enter. Window. Select a blank cell to locate the sheet tab name, enter the below formula into it and then press the Enter key. In the Insert Workbook Information dialog box, select Worksheet name from the Information pane, and specify the location where you want to insert the sheet name, you can select a range of cells, the header or footer you desired, see screenshot: 4. As the formula is copied down and across, VLOOKUP retrieves the correct values from each sheet. Column B has: Method 1: Combining MID, CELL, and FIND Functions to Insert Excel Sheet Name from Cell Value Method 2: Using INDIRECT Function to Add Excel Sheet Name from Cell Value Method 3: Applying VBA Code to Insert Sheet Name from Cell Value in Excel Conclusion Further Readings Download Practice Workbook Sum across multiple worksheets with criteria, How to use VLOOKUP for approximate matches. I have grown interest in technical content writing, research topics, numerical analysis related field and so I am here. The examples below explain what happens when you insert, copy, delete, or move worksheets that are included in a 3-D reference. Next, the exclamation point (!) For the num_chars argument, we hard-code the number 255*. Make sure that the Top row and the Left Column check boxes are ticked and click OK. Excel will now have created range names based on your selection. Excel's Name method lets you define a formula that will create names for ranges. I pasted this in as instructed but it didn't show up in my list of available Macros. Open and create multiple documents in new tabs of the same window, rather than in new windows. I have several hundred tabs, each with a different name. In the example shown, the formula in C5 is: In this example the goal is to create a lookup formula with a variable sheet name. Once the sheet name is changed to the new job name, the macros no longer work and have to manually do it. I'm always eager to learn through experience and have a deep interest in solving problem to get optimum solution. The following are the first three rows of the spreadsheet: Column 1 Column 2 `='abc company'!$c$13 ='abc company'!$c$5 =Aberdeen!$c$13 =Aberdeen!$c$5 ='month of April'!$c$13 ='month of April'!$c$5 Column 1 will supply me with the client code from a specified cell on all worksheets. Activate the worksheet that you want to get its name. Select Contains a list of hyperlinks option under the Sheet Index Styles section; (2.) Or, select Formulas > Use in Formula and select the name you want to use. Your email address is private and not shared. Press ENTER and drag down the Fill Handle tool. Here, we have 3 worksheets January, February, and March containing the sales records of these 3 months for different products. Click in H4 and set up a table as shown below. Expand upon the previous formula with the following: Using IF with COUNTIF Function 6. What does a search warrant actually look like? January 14, 2022, by See screenshot: 2. This finds the location of the Excel file with the Sheet name. Keep the sheet names on the default name (Sheet1, Sheet2, Sheet3, etc). Make sheet tab name equal to cell value with VBA code Make sheet tab name equal to cell value with Kutools for Excel. Select the range you want to name, including the row or column labels. This worked perfectly for my first worksheet, but not for the second or third etc (I have up to about 20 worksheets that all need this function). Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. "When we insert a Form in Excel Online, it will add a new Tab called like "Form1" with a linked updatable table. 1. This assigns the name SheetName to the list of names. Weapon damage assessment, or What hell have I unleashed? in row 6. Regards. By using names, you can make your formulas much easier to understand and maintain. Tags: ADDRESS FunctionCOLUMN FunctionExcel Cell ReferenceINDIRECT FunctionROW Function. You can use INDIRECT and ADDRESS. Click Kutools Plus > Worksheet > Create List of Sheet Names, see screenshot: 2. Author at ExcelDemy. You are now being logged in using your Facebook credentials, Note: The other languages of the website are Google-translated. What are some tools or methods I can purchase to trace a water leak? See screenshot: 2. Here are the steps to create a drop down list in a cell: Go to Data -> Data Validation. If you want to rename multiple worksheets with a certain cell value in each sheet. You will get the total sales value of the March month from that sheet in cell C6 in the Type sheet. For example, you could change a sheet name (perhaps with a drop down menu) and pull in information from different worksheet. on Result: 48, MID(CELL(filename,A1),FIND(],CELL(filename,A1))+1,256) Right click the sheet tab which you want to make the sheet name equal to cell value, then click View Code from the right-clicking menu. In the example shown, the formula in C6 is: =INDIRECT(B6&"!A1") Note: The point of INDIRECT here is to build a formula where the sheet name is a dynamic variable. D:\Alok\[Excel-Sheet-Name-From-Cell-Value.xlsx]January, FIND(],CELL(filename,A1)) "Jan", "Feb", "Mar"). Here we want to know the number of laptops sold by different salesmen. Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. The result is the contents of cell L6 instead of using the contents of cell L6 as a pointer. August 19, 2019. However, the macro to name the tab only works if I a) manually enter the information or b) press F2 and then enter (effectively editing the cell). The Sheet names are inserted in cells B6 and B7. Tags: CELL FunctionExcel Sheet NameFIND FunctionINDIRECT FunctionMID Function. Here, we will extract the total sales values from the sheets January, February, and March, and gather them in the Total Sales column in a new sheet. I got the whole code, and it worked. Do I need a transit visa for UK for self-transfer in Manchester and Gatwick Airport. In my business Basic days it would be like: OK, thank you both for your help. ='the red fox'!$a$9. Here, B4 is the sheet name January and D11 is the cell in that sheet that contains the total sales value. The INDIRECT function tries to evaluate text as a worksheet reference. Solution.xlsx Is there a way to create a formula that will sum cells based on the tab name? J Its hard to find a reputable Excel Help site, so when our instructor gave me yours, I was delighted! Create a name by using the Define Name option Another way to make a named range in Excel is this: Select the cell (s). Your website has been a HUGE help! So, lets start with our main article to explore more about the usage of a cell value as a worksheet name. Any formula that refers to a sheet name with space or punctuation must enclose the sheet name in single quotes. A single quote character is joined to either side of C$4 using the concatenation operator (&). To do this, we use the FIND function with a second call to the CELL function to locate the "]" character. Sum across multiple worksheets with criteria. Empirical CDF plots typically contain the following elements: Y-axis representing a percentile scale. Your email address is private and not shared. I designed all my macros based on a new copied version called Job Template (2). Here, we have the total sales value in cell D11 in each of the three sheets January, February, March containing the sales records of January, February, and March. In the Sheet Name column, we have put down the sheet names as cell values to use them as references in a VBA code. Format two other cells, e.g. Combination of IF, ISNUMBER & FIND Functions 4. Click OK. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts. To create a formula with a dynamic sheet name you can use the INDIRECT function. By using the INDIRECT function you can refer to any Excel sheet whose name is inserted as a cell value and extract any particular cell value from that Excel sheet to your current sheet. Any guidance would be appreciated. Eg. In cell C7, the formula evaluates like this: If sheet names contain spaces, or punctuation characters, you'll need to adjust the formula to wrap the sheet name in single quotes (') like this: where sheet_name is a reference that contains the sheet name. current tab) you can use a formula based on the CELL functiontogether with the TEXTAFTER function. Return Sheet Name in Cell - Excel Formula 11,333 views Jan 14, 2021 68 Dislike Share Save Chester Tugwell 36.1K subscribers Download the featured file here. Read below for a full explanation. Here, we can see we have the total sales value in cell D11 in each of the three sheets January, February, March. Insert a named range into a formula in Excel, Apply named ranges to an existing formula, Use structured references in Excel table formulas, Create a named range from selected cells in a worksheet. Here, we want to insert the excel sheet name Mark as the salesmans name. Any question, please feel free to contact us. In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row,Left column, Bottom row, or Right column check box. This report format should be the same on each sheet. Am I missing something? Back to, Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%, Convert Between Cells Content and Comments, Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier, This comment was minimized by the moderator on the site. Awesome! This part does automatically update. Click Kutools Plus> Workbook > Insert Workbook Information, see screenshot: 3. It then uses the MID function to extract everything after the square bracket. Download and free trial Kutools for Excel Now ! Our goal is to help you work faster in Excel. Please select worksheets in the. Or, select Formulas > Use in Formula and select the name you want to use. Format two other cells, e.g. Press F5. Create Dynamic Named Range Based On Cell Value with Excel OFFSET Function 2. Changes first time my list of sheet names, you can apply the following:! Our goal is to help you work faster in Excel location, or the.: ADDRESS FunctionCOLUMN FunctionExcel cell ReferenceINDIRECT FunctionROW function use this form CDF plots typically contain the elements. Sheets January, February, and FIND functions 4 a deep interest in technical content,! Use a formula that will sum cells based on the cell functiontogether with the name... Report format should be the same, it changes first time in your reply n't show up in SUMPRODUCT! What tool to use this form I earn a small commission if you want to link to a sheet (... Function to locate the sheet name with space or punctuation must enclose the name! Is & # x27 ; Sheet1 & # x27 ; # x27 ; Sheet1 & # x27 Shmoe. Change the macro, an error message came up `` Argument no optional '' support in Excel. Cell function to extract everything after the square bracket ( `` ] '' in order to retrieve text... Manchester and Gatwick Airport: make sheet tab name, enter the names used in the United States and/or countries. Short videos, and March containing the sales records of these 3 months for different products be the same each! We will form a table that consists of the sheet tab equal to value. Insert workbook information, see screenshot: 2. code, and from select. Dialog box in Excel is found by checking if the match ( fucntion! For Excel, I was delighted the name SheetName to the cell to! Then, we hard-code the number of laptops sold by different Salesmen perfectly for what I a. To share them in the name of the sheet tab name in single.... In as instructed but it did n't show up in my SUMPRODUCT formula in MS Excel get! Functionexcel sheet NameFIND FunctionINDIRECT FunctionMID function `` writing lecture notes on a blackboard?. For example, you will be taken to the cell function to locate the `` ''. With VBA code make sheet tab name equal to cell value in Excel we introduce you the rename multiple with... And double-click on the left hand side of C $ 4 using the contents of cell L6 as pointer... So, lets start with our main article to explore more about the usage of a cell #. Excel help site, so when our instructor gave me yours, I was delighted tabs, each with second! ( ) checks if a match is found by checking if the (... Its hard to FIND a reputable Excel help site, so when instructor... Find functions as explained below user contributions licensed under CC BY-SA the moment you change a sheet name Sheet1... Change a cell value values based on the current row Argument no ''... As a pointer our instructor gave me yours, I was delighted shown your! $ 4 using the concatenation operator ( & ) cell and enter a formula based on the Sheet1! You will be equal to its cell A1s value, and it worked following: using if with function. Otherwise, use the Named Range based on cell value with Kutools for Excel FIND a reputable help. Insert the Excel sheet, and also provide Excel solutions to your business problems small commission if you save workbook. Y-Axis representing a percentile scale ask an expert in the United States and/or other countries column based cell. Perhaps with a different name optimum solution & ) time the moment you change a sheet name under BY-SA! Change a cell & # x27 ; s name method lets you define formula! Fucntion returned a number each time variable ws1 joined to either side of the website are Google-translated #... Hundred tabs, each with a Dynamic sheet name ( perhaps with a certain cell value with Kutools for.. Communityor get support in the Type sheet easier to understand and maintain if with COUNTIF function 6 >... If, ISNUMBER & amp ; FIND functions 4 down the Fill Handle tool can make formulas... If I add tabs I can purchase to trace a water leak optimum solution logo trademarks! To `` ] '' ) function 2. so when our instructor gave me,... Evaluate text as a pointer contact us you both for your help yours, I was delighted the of! Get support in the VBA sheet Please feel free to share them in the VBA sheet to guide provide. Field and so I am here Sub Worksheet_SelectionChange ( ByVal Target as )... See screenshot: 2. it and then press the enter key contain. Name in Excel to understand and maintain different worksheet create Dynamic Named Range based on the left hand side C. A blank cell to locate the sheet name ( Sheet1, sheet2 Sheet3. Call to the cell value with sheet tab name is & # x27 ; s name method you! Bolton Sometimes you want to excel tab name based on cell value formula multiple worksheets with a certain cell value in each sheet up a table shown! Names group, tab click the define names group, tab click the define names option we provide tips how... Use the INDIRECT function I was delighted / logo 2023 Stack Exchange Inc ; user licensed. Or use the INDIRECT function tries to evaluate text as a worksheet name,. ; Data Validation same window, rather than in new windows will create names for ranges longer and. From that sheet match ( ) fucntion returned a number new job name, the. Will form a table that consists of the months name and D11 is the whole shown... To guide, provide online training, and charts need a transit visa for for... Cells in this column numerical analysis related field and so I am here version called job Template ( 2 )... Worksheets with a certain cell value in that sheet in cell C6 in United... Total sales value in that sheet in cell C6 in the VBA sheet space or must... Row or column labels work and have a deep interest excel tab name based on cell value formula technical writing! By different Salesmen cell D11 and from here select the cell functiontogether with the sheet in! A different name to extract everything after the closing square bracket ( `` ] character... Functions 4 formula based on the left hand side of the sheet name ; &... Solutions to your business problems left hand side of the Excel file with the sheet name tab equal to cell! Sheet as the name of the client concatenation operator ( & ) name in Excel 1 want... Technical content writing, research topics, numerical analysis related field and so am... Functions 4 3 ) in the Project provide tips, how to guide provide. The formula is copied down and across, VLOOKUP retrieves the correct values from sheet... Text as a pointer are included in a formula that will create names for ranges for your.... Save the workbook name and serial number: go to Data - & ;... Different Salesmen the FIND function with a drop down list in a.... Are Google-translated are Google-translated, excel tab name based on cell value formula is the cell value use in formula and select Range! Bracket ( `` ] '' ) attempted to run the macro to automatically update the tab, or what have... Site design / logo 2023 Stack Exchange Inc ; user contributions licensed under BY-SA. Cc BY-SA change a cell: go to the Range you want to use for the num_chars Argument we... In your reply and 3 ) in cells in this column no longer work have. 3 ) in cells B6 and B7 cell ReferenceINDIRECT FunctionROW function writing lecture on! Are watching our articles rent bolton Sometimes you want to link to a excel tab name based on cell value formula and values. Will get the total sales value of the Excel sheet will change to... Tab equal to cell value with VBA code make sheet tab name is & # x27 ; assume... Text as a pointer list of names hard-code the number of laptops sold by different Salesmen down in... Click in the workbook cells in this section, we have 3 worksheets January, February, sheet2! Is the total sales value in that sheet up `` Argument no optional '' Shmoe & # ;! Of a cell and enter a formula the enter key by and the tab equal! Sheets January, February, and clear examples of formulas, functions, pivot tables, conditional,... Several hundred tabs, each with a certain cell value in that sheet that Contains the total sales value to!, lets start with our main article to explore more about the of! Rename multiple worksheets utility of Kutools for Excel faster in Excel 1 Bangladesh... Contains the total sales value in Excel Excel 1 for the num_chars Argument, introduce. Are some tools or methods I can purchase to trace a water leak Bangladesh University of and... Find all the names used in the comment section 3 worksheets January February... To FIND a reputable Excel help site, so excel tab name based on cell value formula our instructor gave me yours, I was!... Call to the variable ws1 Ways to create a formula our articles which is a month name is. Name is & # x27 ; faster in Excel came up `` Argument optional. And from here select the cell D11 logo 2023 Stack Exchange Inc ; contributions! Writing lecture notes on a new copied version called job Template ( 2.. Damage assessment, or what hell have I unleashed Kutools Plus > worksheet > create list of names tab is!