User Posts: Alok
How to Select Every Other Column in Excel (3 Methods)

Microsoft Excel is one of the most widely used applications in today's world. It is very popular with individuals and small & medium business enterprises. ...

Percentage Showing as Thousand in Excel (Reason and Solution)

The percentage is the ratio of one number compared with the total presented in terms of 100. The use of percentages is very common in today's life. Mostly, it ...

Convert Number to Percentage Without Multiplying by 100 in Excel

The percentage is the fraction of two numbers multiplied by 100. Mathematically, we need to multiply a number by 100 to convert that into a percentage. But ...

How to Make a Cheque Payment Voucher Format in Excel

This article is mainly about payment vouchers. A payment voucher is a record of payment of any organization, and this is sent to the supplier. There are ...

How to Find Column Index Number in Excel VLOOKUP (2 Ways)

We all know that the VLOOKUP function in Excel has 4 arguments. One of them is the col_index_num. i.e. column index number. Finding the column index number is ...

How to Sum Absolute Value in Excel (6 Suitable Ways)

The absolute value is used to present the difference between two entities. After calculation, the resultant difference may be positive or negative. The ...

How to Make a Percentage Line Graph in Excel (2 Suitable Ways)

The line graph is one of the basic graphs of Excel. We can simply select data and choose the line chart to make a line graph. But adding percentages in the ...

How to Calculate Annual Salary in Excel (with Detailed Steps)

Microsoft Excel has huge uses in different sectors. Mostly, medium and small enterprises and companies use Microsoft Excel to save costs from using paid ...

How to Calculate Mean Percentage Error in Excel

The mean percentage error is one kind of error calculation technique. It presents the mean or average error. In this article, we will discuss how to calculate ...

How to Calculate SLA Percentage in Excel (with Quick Steps)

SLA is one kind of contract between companies to ensure the service quality of a product or service. SLA is very important to maintain service quality. This ...

How to Calculate Percentage Share in Excel (3 Suitable Ways)

Percentage share is a popular term in business organizations. In other sectors, this term is also used. We will calculate the percentage share in Excel based ...

How to Create a Hierarchy of the State City and Zip Code in Excel

To express an address, usually we need state, city name, and code. In a state, there are several cities. And under one city there are several zip code areas. ...

How to Make Excel Go to Next Line Automatically (2 Examples)

We can go to the next cell in Excel easily by pressing the Enter button. But going to the next line in the same cell is not quite easy. We can do this by ...

How to Convert INR to USD in Excel (4 Methods)

Conversion of currency is very common now. People visit from one country to another, they need to convert their currency. In case of buying any product from ...

Convert Time to Minutes in Excel (5 Suitable Methods)

Hour, minute, and second are the units of time. In different situations, we show time with the combination of these units. Such as HH:MM:SS, HH: MM, MM:SS, HH, ...

Browsing All Comments By: Alok
    Thanks for reading our articles. We have found a solution to fulfill your requirement. You need to insert the following macros with the existing VBA code.

    Worksheets(ActiveSheet.Index + 1).Select
    ActiveSheet.Name = (Worksheets(2).Range("A1").Value) & " " & ActiveSheet.Name

    Here, Worksheets(2).Range(“A1”).Value defines we want to insert the text of Cell A1 of Worksheet 2 with the current sheet name.
    Have a look at the image below, where to insert the mentioned VBA code.
    Split Data

  2. Hi NAYAZ,
    Thanks for following our article. We have checked the article again and found no errors. Please go through the whole article again and create the template. Or you can do this easily by downloading the given template.
    Keep in mind that if you want to import stock prices from any other website, then it will not work. You should use “^NSEI” in the ticker box.
    Let us know if your problem is fixed.
    -Alok Paul
    Author at ExcelDemy

  3. Hello, DANIEL.
    Thanks for reading our articles.
    Look at the below link. Hopefully, you will get your solution.

    For example, you can use the following code:

    Sub Extract_Data()
    Application.CutCopyMode = False
    End Sub

    Enter your sheet name instead of Dataset2 in the 3rd line. Change the cell range in the 4th line. Hope you will get desired output. If your problem is yet solved, then let us know.
    -Alok Paul
    Author at ExcelDemy

  4. Hello, CL.
    Of course, it’s possible to solve your mentioned problem!
    You will need to get the ASCII code of the respective keys. Now, open a new Excel file and follow all the steps written in this article, i.e. downloading Barcode fonts 128, installing them, creating a UDF, and the next steps. Now insert the ASCII codes of the respective keys and you will get your desired Barcode. See what we have got.
    Keyboard keys to Barcode
    So, what you need to do yourself, just finding the ASCII codes! What else to do are already mentioned in this article.

    Note: You may need to open a new file because as per the new update of Excel, a VBA code will be disabled in a downloaded xlsm file. Or you can solve the problem following this way.

  5. Hi DAVID,
    Thank you very much for your appreciation. Follow our website ExcelDemy for other problems, and hope you will always get the best solutions.

  6. Hello JEFF WHALE,

    Thank you very much for following our articles.

    You mentioned that your sample code is not working properly. We attached a VBA code that will help you to solve this problem. You need to choose a cell from the dataset that contains an ISBN number when running the code. One thing adding that change the location of Chrome according to your computer.

    And you are getting this 404 error because without any ISBN number this will show an error by default.

    Sub OpenstrHyperlinkInChrome()
    Dim strChromeLocation As String
    Dim strURL As String
    Dim strISBN As String
    strISBN = Application.InputBox("Please Select Desired Cell", Type:=8)
    strURL = "" & strISBN
    strChromeLocation = """C:\Program Files\Google\Chrome\Application\chrome.exe"""
    Shell (strChromeLocation & "-url " & strURL)
    End Sub

  7. Hi BARNEY! Hope you are doing well. Thanks for your nice compliments. We are happy to know that the readers find our articles useful.
    However, the problem you are facing is not quite clear from what you have told us. Are you trying to sum up entries that meet specific criteria? In that case, you have to use the SUMIF function if you have to meet just a single criterion. If you have multiple criteria, then you have to use the SUMIFS function. There are more articles in our blog related to these functions. To explore them, scroll down and click on the function tag names.

    If this is not what you are looking for, please let us know more details. You can send me the problem with a sample file at [email protected] or at [email protected].

    Best wishes. Keep staying with us.
    -Alok Paul
    ExcelDemy Team

    You probably have missed this part. The solution to your problem is already given in the article.
    Click the below link and will get the solution.
    If I am not wrong, this is what you are searching for. As far as we know, you cannot undo protection to a password-protected file, but save a copy of it without password protection. If this is not your case, please let us know a bit more details.
    Thanks for being with us.

  9. Hi JEFF! Thanks for your nice compliment. To remove the InputBox and make the code always select Column 1, just remove the InputBox command and variable VCL. After that, replace the VCL with 1.
    You can directly use the following code:

    Sub Split_Data()
    Dim L As Long
    Dim DS As Worksheet
    Dim XCL As Long
    Dim MARY As Variant
    Dim title As String
    Dim titlerow As Integer
    Application.ScreenUpdating = False
    Set DS = ActiveSheet
    L = DS.Cells(DS.Rows.Count, 1).End(xlUp).Row
    title = "A1"
    titlerow = DS.Range(title).Cells(1).Row
    XCL = DS.Columns.Count
    DS.Cells(3, XCL) = "Unique"
    For X = 2 To L
    On Error Resume Next
    If DS.Cells(X, 1) <> "" And Application.WorksheetFunction.Match(DS.Cells(X, 1), DS.Columns(XCL), 0) = 0 Then
    DS.Cells(DS.Rows.Count, XCL).End(xlUp).Offset(1) = DS.Cells(X, 1)
    End If
    MARY = Application.WorksheetFunction.Transpose(DS.Columns(XCL).SpecialCells(xlCellTypeConstants))
    For X = 2 To UBound(MARY)
    DS.Range(title).AutoFilter field:=1, Criteria1:=MARY(X) & ""
    If Not Evaluate("=ISREF('" & MARY(X) & "'!A1)") Then
    Sheets.Add(after:=Worksheets(Worksheets.Count)).Name = MARY(X) & ""
    Sheets(MARY(X) & "").Move after:=Worksheets(Worksheets.Count)
    End If
    DS.Range("A" & titlerow & ":A" & L).EntireRow.Copy Sheets(MARY(X) & "").Range("A4")
    DS.AutoFilterMode = False
    Application.ScreenUpdating = True
    End Sub

  10. You are most welcome, MANUEL!
    We provide the best and easy solutions to Excel-related problems. You are invited to visit our blog for more such articles.

  11. If the last two rows contain the same data, then it fails to delete both rows. Otherwise, it works.