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

Match() function

-
Image
Match() function MATCH is an Excel function used to locate the position of a lookup value in a row, column, or table. MATCH supports approximate and exact matching, and  wildcards  (* ?) for partial matches. Often, the  INDEX function  is combined with MATCH to retrieve the value at the position returned by MATCH. Syntax The syntax for the MATCH function in Microsoft Excel is: =MATCH (lookup_value, lookup_array, [match_type]) Parameters or Arguments lookup_value The value to search for in the array. lookup_array A range of cells that contains the value that you are searching for. match_type Optional. It the type of match that the function will perform. The possible values are: Match_type Explanation 1 (default) The MATCH function will find the largest value that is less than or equal to value. You should be sure to sort your array in ascending order. If the match_type parame...
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

Int() Function

-
Image
Int() Function The Excel INT function returns the integer part of a decimal number by rounding down to the integer. Note the INT function rounds down, so negative numbers become more negative. For example, while INT(10.8) returns 10, INT(-10.8) returns -11. Syntax The syntax for the INT function in Microsoft Excel is: =INT( expression ) Parameters or Arguments expression A numeric expression whose integer portion is returned. Excel Int Function Examples The following spreadsheets show the Excel Int function applied to different numbers: Formulas: A B 1 =INT(100.9) 2 5.22 =INT( A2 ) 3 5.99 =INT( A3 ) 4 99.5 =INT( A4 ) 5 -6.1 =INT( A5 ) 6 -100.9 =INT( A6 ) Results: A B 1 100 2 5.22 5 3 5.99 5 4 99.5 99 5 -6.1 -7 6 -100.9 -101 The above examples show how the Int function always rounds down. Even with negative numbers, the ...
Read more