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

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

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

Vlookup() function

-
Image
Vlookup() function VLOOKUP is an extremely useful tool, and learning how to use it is easier than we think! The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. Syntax =VLOOKUP( Value you want to look up,   range where you want to lookup the value,   the column number in the range containing the return value,   Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE ). There are four pieces of information that you will need in order to build the VLOOKUP syntax: Value The value you want to look up, also called the lookup value. Table The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example...
Read more