How to create new sheet and name through a cell range

-
How to create new sheet  and name through a cell range

go to developer tab and create a macro using below code

Sub CreateSheets()

Sheets("Sheet 1").Select
Words = Cells.Range ("A2:A46")
For Each Item In Words
Sheets.Add After:=Sheets(Sheets.Count)
Sheets(Sheets.Count).Name = Item
Next Item
End Sub





Comments

Post a Comment

Popular posts from this blog

IfError() Function

-
Image
IfError() Function The Excel IFERROR function returns a custom result when a formula generates  an error , and a standard result when no error is detected. IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements. Syntax The syntax for the IFERROR function in Microsoft Excel is: =IFERROR( formula, alternate_value ) Parameters or Arguments formula The formula or value that you want to test. value_if_error The alternate value that is returned if the formula results in an error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL). Otherwise, the function will return the result of the formula if no error occurs. Excel Iferror Function Examples Example 1 The following spreadsheet shows two simple examples of the Excel Iferror function. Formulas: A B C 1 1 2 =IFERROR( A1 / B1, 0 ) 2 1 0 =IFERROR( A2 / B2, 0 ) Results: A B C 1...
Read more

How to Insert Rows in Excel Worksheet using VBA – Solution(s)

-
Image
How to Insert Rows in Excel Worksheet using VBA – Solution(s): We can insert use EntireRow.Insert method to insert rows. The following is the example code to inserting rows in excel worksheet. VBA insert rows excel – An Example The following example will show you how to insert a row in Excel Worksheet. You can insert multiple rows at a time. Code: Sub sbInsertingRows() 'Inserting a Row at at Row 2 Range("A2").EntireRow.Insert ' 'Inserting 3 Rows from 3 Rows("3:5").EntireRow.Insert End Sub Instructions: Open an excel workbook Press Alt+F11 to open VBA Editor Insert a Module for Insert Menu Copy the above code and Paste in the code window Save the file as macro enabled workbook Press F5 to run it Input: Shcreen-shot of example, before executing of the above code. You can see the 10 rows of data available in the worksheet. Output: Shcreen-shot of example, after executing of the above code. You can see the 4 new rows are inserted...
Read more

Using INDEX MATCH MATCH

-
Image
Using INDEX MATCH MATCH If you use  INDEX MATCH  frequently in your worksheets, you may be surprised to learn about an even more powerful version of the formula:  INDEX MATCH MATCH . This variant allows you to look up values across rows and columns simultaneously. Let's take a look at how this new construction works.  Proficiency with the basic  INDEX MATCH  formulation is a prerequisite for this tutorial. If you don't already have a solid grasp of it, check out our basic  INDEX MATCH tutorial first. Defining the problem The following spreadsheet lists two metrics —  Cookie packs sold  and  Revenue  — for SnackWorld by month from January through May. We know how to run an  INDEX MATCH  on either one of these columns to pull a specific metric by month, using the standard formula: = INDEX ( range , MATCH ( lookup_value , lookup_range , match_type )) But, what if we also want to add a flexible input ...
Read more