User Posts: Alok
How to Make a Confidence Interval Graph in Excel (3 Methods)

The confidence interval is one kind of add-on to a graph. When there is some uncertainty factor that exists in a dataset, we use this confidence interval in a ...

Convert Time to Text in Excel (3 Effective Methods)

In this article, we will show the ways to convert time to text in Excel with proper illustrations. The following image shows the input and output briefly. ...

Add 15 Minutes to Time in Excel (4 Easy Methods)

In workstations, we use MS Excel to record our entry time, exit time, and working period. Sometimes we need to manipulate those times due to different ...

How to Remove Unknown Links in Excel (4 Suitable Examples)

Sometimes we use the information of one Excel file for other. This way, we link Excel files one to another. Sometimes we see that, there are unknown links are ...

How to Merge Two Excel Sheets Based on One Column (3 Ways)

In small businesses or corporate organizations, we use MS Excel to collect data. Information about the same people or entity is stored in different sheets. ...

How to Select Multiple Columns in Excel for Graph (3 Methods)

To create a chart, we need a minimum of two variables for two axes. That means we need two rows or columns in Excel. In this article, we will show how to ...

How to Put Comma After 5 Digits in Excel (5 Methods)

Commas are used to represent numbers properly. There is some format of using commas with a number. Usually, commas are used after 3 digits in a number. But ...

Excel VBA to Add Sheet to Another Workbook (3 Handy Examples)

Do you want to add a sheet to another workbook in Excel? Yes, then you are in the right place! You can add a sheet in Excel in different ways. Microsoft Visual ...

How to Calculate Coupon Payment in Excel (4 Suitable Examples)

Coupons are issued against the bonds. Coupon payments are given based on the interest rate. In this article, we will discuss how to calculate coupon payment in ...

How to Average Letter Grades in Excel (4 Suitable Formulas)

Average letter grades are popularly used in educational institutions to represent the results. We can easily perform this using MS Excel. There are several ...

Formula for Business Days in Excel (3 Examples)

Not all 7 days of a week are business days! Business days indicate the working days. In an official week, weekends exist too. Not only that, there are some ...

How to Insert a Footer in Excel (2 Suitable Ways)

Headers and footers are used in Excel Sheets to show some information at the top and bottom respectively of each sheet. When we print the Excel file those are ...

VBA Code to Convert XML to Excel (Apply with Quick Steps)

XML files are used for data purposes. But when we need to use this data, we can not open an XML file directly using MS Excel. However, there are some tricks to ...

How to Calculate Annual Cash Flow in Excel (with Easy Steps)

Annual Cash flow is the amount of money invested for a whole year. This article will discuss how to calculate annual cash flow in Excel with the proper ...

How to Change Border Color in Excel (3 Suitable Ways)

In Microsoft Excel cells are distinguished by cell borders. But sometimes border colors are not visible. In that case, we need to change the border color. In ...

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 alokpaul75[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.