Shamima Sultana

About author

Shamima Sultana, BSc, Computer Science and Engineering, East West University, Bangladesh, has been working with the ExcelDemy project for 2 years. She has written over 75+ articles and reviewed 1000+ articles for ExcelDemy. She has also led several teams with Excel VBA and Content Development works. Currently, she is working as the Project Manager and oversees the day-to-day work, leads the services team, allocates resources to the right area, etc. Her work and learning interests vary from Microsoft Office Suites, and Excel to Data Analysis, Data Science, VBA, Python, and developing Excel Applications.

Designation

Project Manager at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.sc in Computer Science and Engineering (CSE), East West University.

Expertise

Data Analysis, Content Writing, C, C++, Python, JavaScript (Basic), HTML, SQL, MySQL, PostgreSQL, Microsoft Office.

Experience

  • Project Management
  • Technical Content Writing
  • Team Management
  • Software Engineer
    • Data Architecture [Analysis and Diagram]
    • Data Governance [Using Excel and Postgre SQL]
    • 3D Object Visualization [Using Python]
  • Undergraduate Projects
    • Industrial Visit Planning Website
    • Database Management System
    • Factoid Question Answering System (over Bangla Comprehension)

Summary

  • Currently working as Project Manager of ExcelDemy
  • Started technical content writing of Excel & VBA in October 2021 later prompted as Team Leader for Content Management.
  • I worked at Adipster Tech Limited as a Software Engineer from November 2020 – May 2021. I’ve Done several real-life projects and documented several projects with analytical reports.

Research & Publication

Latest Posts From Shamima Sultana

0
How to Remove Leading Spaces in Excel (4 Easy Methods)

While creating a large worksheet it is very much possible to have some extra spaces in the contents. To make an excellent worksheet it is needed to remove ...

0
How to Count Months in a Column in Excel (4 Quick Ways)

Sometimes, you may need to count the months in a column to see in the same month which projects or works are running or had been happened. In this article, I’m ...

0
How to Count Months in Excel (5 Easy Ways)

When we want to keep track of a particular project and work, and many more then it is important to count the months. To keep track we need to count the month ...

0
How to Select Every Other Row in Excel (6 Easy Ways)

Today, we are going to show how to select every other row in Excel. While performing functions or formulas in multiple rows we may require selecting every ...

0
How to Compare Three Columns and Return a Value in Excel

We may need to extract data by comparing three columns or to get an insight into data we may need to compare three columns. In this article, I will explain how ...

0
How to Match Names in Excel Where Spelling Differ (8 Methods)

Comparing data in Excel rows is common while doing any data analysis task. In this article, I’ve explained eight methods to match names in Excel where spelling ...

0
Excel Remove Characters From Right (5 ways)

It is possible to have any extra characters in the Excel cell. Sometimes, to generate a different value from existing values you may require to remove ...

0
How to Delete a Cell in Excel (4 Easy Ways)

If you are looking for some special tricks to know how to delete a cell in Excel, you've come to the right place. We’ll show 4 suitable methods to delete a ...

0
How to Insert Pictures Automatically Size to Fit Cells in Excel (3 Suitable Methods)

Fortunately, many of us use Excel in our business organizations. In any business organization, we use Excel to organize data as per need and make databases for ...

0
How to Delete Selected Rows in Excel?

Sometimes we need to remove some unwanted rows from the sheet in Excel. We can do it using the delete option. In this article, I’m going to explain how to ...

0
How to Show and Hide Formula Bar in Excel (3 Suitable Methods)

To show and hide the Formula Bar in Excel: Go to the View tab > Show group. Mark the Formula Bar checkbox to show it. Unmark the checkbox to hide ...

0
How to Use Sheet Name in Dynamic Formula in Excel

Sometimes depending on the scenario, you may need to use worksheet names in the formula, providing the sheet name manually is a tedious task. To assist you in ...

1
Difference Between Absolute and Relative Reference in Excel

In Excel, there are mainly two types of references: Relative and Absolute (although there is another reference called mixed reference). In this article, we ...

0
How to Merge Rows with Same Value in Excel (5 Quick Ways)

We often face some datasets, that have some repetitive values. In that case, it is very convenient to merge those rows and show them in a single cell. In this ...

0
How to Combine Multiple Rows into One Cell in Excel (6 Ways)

Excel is a popular and useful tool for analyzing large sets of data. Sometimes we need to show the multiple rows of data in one cell to mean something or to ...

Browsing All Comments By: Shamima Sultana
  1. Hi Arda
    Hope you are doing well.

    I checked the code you mentioned above and it works. To make it more clear I’m attaching some images with the code.

    Here, I tried the exact code in the same dataset.
    MsgBox Range("E5").End(xlToRight).Offset(0, 1).Address

    You can see the result $G$5.

    Again I changed the dataset slightly.

    Here, the result is also based on the location.

    NB. If it doesn’t help you then please send your dataset to [email protected] or [email protected]

    Thanks
    Shamima Sultana
    ExcelDemy

  2. Hello Terry Wayne Sutfin,

    Thanks for your appreciation, it means a lot to us.

    Regards
    ExcelDemy

  3. Hello Margit,

    You are most welcome.

    Regards
    ExcelDemy

  4. Hello Jitendra Sahu,

    Thanks for your kind words. Our goal is to make Excel easy for everyone.

    Regards
    ExcelDemy

  5. Hello Melissa,

    We are glad that our article solved your problem. You are most welcome. Thanks for your appreciation.

    Regards
    ExcelDemy

  6. Hello Robert,

    You are most welcome. Thanks for your appreciation.

    Regards
    ExcelDemy

  7. Hello Ayokanmi,

    Thanks for your appreciation. You are most welcome. Our paid courses are in Udemy not in WordPress. But we have 7500++ free tutorials and 340+ YouTube videos. You can explore these learning materials for free.

    Regards
    ExcelDemy

  8. Hello Feven,

    You are most welcome.

    Regards
    ExcelDemy

  9. Hello Brent Hamilton,

    Thank you for your feedback. We used Microsoft 365 at work. We apologize for any confusion caused. The reason the “Show Changes” feature only becomes available after saving the file on OneDrive for real-time collaboration and tracking of changes. If you save it on OneDrive, it allows Excel to track changes made by different users and enables the “Show Changes” feature to display those revisions. This integration with OneDrive enhances collaboration and ensures that users can effectively manage changes made to shared documents.

    Regards
    ExcelDemy

  10. Hello David Rascati,

    You are most welcome. If you want you can share your code here so that we can debug it to find out the reason.

    Regards
    ExcelDemy

  11. Hello Mervyn,

    Thanks for visiting our blog and sharing your questions. You wanted to clarify the difference between a Table and a Dynamic Table.

    Table and Dynamic table may look similar but they are not same.
    In the context of the article,
    Regular Table – is created manually by the user within Excel’s interface.
    Dynamic Table – is generated automatically using VBA code.

    When data is turned into a table, Excel automatically adds functions like sorting, filtering, and structured referencing. These tables are dynamic and adjust automatically when the data changes.

    But a Dynamic Table in the article’s context likely refers to a table created dynamically using VBA code from a range. It is able to automatically manage specific criteria or changes.

    Regards
    ExcelDemy

  12. Hello Phil Hall,

    If you want the Excel Workbook of this article you will get it from Download Practice Workbook section.

    If you want the get the advanced exercises from “Get FREE Advanced Excel Exercises with Solutions!” button please fill your information correctly in the form. Next, you will get the exercise list in your given email. For your concern I tried it again it’s working perfectly.

    Exercise mail

    Regards
    ExcelDemy

  13. Hello Vijay,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  14. Dear RB,

    You are most welcome.

    Regards
    ExcelDemy

  15. Dear SKM,

    You are most welcome.

    Regards
    ExcelDemy

  16. Dear Sudarshan Dhuru,

    You are most welcome. Thanks for your appreciation it means a lot to us.

    Regards
    ExcelDemy

  17. Dear Xyand,

    You are most welcome. Thanks for appreciation. We updated the image of Method 6.

    Regards
    ExcelDemy

  18. Hello Saeed Anwar,

    You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  19. Hello Minzameera,

    Hope you are doing well. Here we calculated the overtime based on your criteria. We assumed that this time spans are for one person. If these are for different person you can modify the formula.

    Formula ta calculate working hours: =(IF(B2

    Formula

    Formula to calculate the total working hours: =C2+C3

    formula 2

    Formula to calculate the overtime, here we assumed the working hours are 8: =IF(D2>B6,D2-B6,”No Overtime”)

    overtime

    Regards
    ExcelDemy

  20. Hi Paulinus Friday,

    You are most welcome. Data Files are available in the Excel Practice file section.

    Regards
    ExcelDemy

  21. Hello ابو معاذ,

    You are most welcome.

    Regards
    ExcelDemy

  22. Hello Dwbi,

    You are most welcome.

    Regards
    ExcelDemy

  23. Hello Rao,

    We will try to upload it in our up coming videos.

    Regards
    ExcelDemy

  24. Hello Jessica H,

    You are most welcome.

    Regards
    ExcelDemy

  25. Hello Jennifer,

    You are most welcome.

    Regards
    ExcelDemy

  26. Hello Federico Cofederi,

    To send Email without pressing “Send” you can use .Send property in your code instead of .Display.

    Option Explicit
    Sub Send_Email_Condition()
        Dim xSheet As Worksheet
        Dim mAddress As String, mSubject As String, eName As String
        Dim eRow As Long, x As Long
        Set xSheet = ThisWorkbook.Sheets("Conditions")
        With xSheet
            eRow = .Cells(.Rows.Count, 5).End(xlUp).Row
            For x = 5 To eRow
                If .Cells(x, 4) >= 1 And .Cells(x, 5) = "Obama" Then
                    mAddress = .Cells(x, 3)
                    mSubject = "Request For Payment"
                    eName = .Cells(x, 2)
                    Call Send_Email_With_Multiple_Condition(mAddress, mSubject, eName)
                End If
            Next x
        End With
    End Sub
    Sub Send_Email_With_Multiple_Condition(mAddress As String, mSubject As String, eName As String)
        Dim pApp As Object
        Dim pMail As Object
        Set pApp = CreateObject("Outlook.Application")
        Set pMail = pApp.CreateItem(0)
        With pMail
            .To = mAddress
            .CC = ""
            .BCC = ""
            .Subject = mSubject
            .Body = "Mr./Mrs. " & eName & ", Please pay the due amount within the next week." _
            & vbNewLine & "The exact amount is attached with this email."
            .Attachments.Add ActiveWorkbook.FullName 'Send The File via Email
            .Send 
        End With
        Set pMail = Nothing
        Set pApp = Nothing
    End Sub
    

    Regards
    ExcelDemy

  27. Hello Obinna,

    You are most welcome.

    Regards
    ExcelDemy

  28. Hello Prakash,

    You are most welcome.

    Regards
    ExcelDemy

  29. Hello Salomé Magerstein,

    You are most welcome.

    Regards
    ExcelDemy

  30. Hello Kristi,

    You are most welcome.

    Regards
    ExcelDemy

  31. Hello Muhammad Ismail Jumarang,

    You are most welcome.

    Regards
    ExcelDemy

  32. Hello Lory,

    You can use the following formula: =IFERROR(INDEX(‘Round 1′!$B$3:$AJ$25,MATCH(A5,’Round 1’!$B$3:$B$25, 0),34),””)
    It will leave a cell blank if no matches are found.

    Regards
    ExcelDemy

  33. Hello Kndn,

    The Measuring unit of the result is “Mile”.

  34. Hello,

    You are most welcome.

    Regards
    ExcelDemy

  35. Hello,

    You are welcome.

    Regards
    ExcelDemy

  36. Dear Icarus Builders,

    You are most welcome.

    Regards
    ExcelDemy

  37. Hello Vini,

    Updated the code spilt data into multiple Excel file.

    Sub Split_Data_Multiple_Files()
        Dim L As Long
        Dim DS As Worksheet
        Dim VCL As Integer
        Dim XCL As Long
        Dim MARY As Variant
        Dim title As String
        Dim titlerow As Integer
        Dim newWorkbook As Workbook
        Dim newSheet As Worksheet
        Dim filePath As String
        
        Application.ScreenUpdating = False
        
        VCL = Application.InputBox(prompt:="Which column would you like to filter by?", title:="Filter column", Type:=1)
        Set DS = ActiveSheet
        L = DS.Cells(DS.Rows.Count, VCL).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, VCL) <> "" And Application.WorksheetFunction.Match(DS.Cells(X, VCL), DS.Columns(XCL), 0) = 0 Then
                DS.Cells(DS.Rows.Count, XCL).End(xlUp).Offset(1) = DS.Cells(X, VCL)
            End If
        Next
        
        MARY = Application.WorksheetFunction.Transpose(DS.Columns(XCL).SpecialCells(xlCellTypeConstants))
        DS.Columns(XCL).Clear
        
        For X = 2 To UBound(MARY)
            DS.Range(title).AutoFilter field:=VCL, Criteria1:=MARY(X) & ""
            Set New_Workbook = Workbooks.Add
            Set New_Sheet = newWorkbook.Sheets(1)
            DS.Range("A" & titlerow & ":A" & L).EntireRow.Copy New_Sheet.Range("A4")
            DS.AutoFilterMode = False
            New_Sheet.Columns.AutoFit
            filePath = ThisWorkbook.Path & "\" & MARY(X) & ".xlsx"
            New_Workbook.SaveAs filePath
            New_Workbook.Close False
        Next
        
        DS.Activate
        Application.ScreenUpdating = True
    End Sub
    

    Regards
    ExcelDemy

  38. Hello Syed Mohisn Ahmed,

    Updated the code in the marked section. Where I replaced “Rupees” text from condition.

    Updated Code

    You can use the following code.

    Function word(SNum As String)
    'Declare the Variables
    Dim zDPInt As Integer
    Dim zArrPlace As Variant
    Dim zRStr_Paisas As String
    Dim zNumStr As String
    Dim zP As Integer
    Dim zTemp As String
    Dim zStrTemp As String
    Dim zRStr As String
    Dim zBp As Integer
    zArrPlace = Array("", "", " Thousand ", " Lacs ", " Crores ", " Trillion ", "", "", "", "")
    On Error Resume Next
    If SNum = "" Then
      word = ""
      Exit Function
    End If
    zNumStr = Trim(Str(SNum))
    If zNumStr = "" Then
      word = ""
      Exit Function
    End If
     
    zRStr = ""
    zBp = 0
    If (zNumStr > 999999999.99) Then
        word = "Digit excced Maximum limit"
        Exit Function
    End If
    zDPInt = InStr(zNumStr, ".")
    If zDPInt > 0 Then
        If (Len(zNumStr) - zDPInt) = 1 Then
           zRStr_Paisas = word_GetT(Left(Mid(zNumStr, zDPInt + 1) & "0", 2))
        ElseIf (Len(xNumStr) - xDPInt) > 1 Then
           zRStr_Paisas = word_GetT(Left(Mid(zNumStr, zDPInt + 1), 2))
        End If
            zNumStr = Trim(Left(zNumStr, zDPInt - 1))
        End If
        zP = 1
        Do While zNumStr <> ""
            If (zP >= 2) Then
                zTemp = Right(zNumStr, 2)
            Else
                If (Len(zNumStr) = 2) Then
                    zTemp = Right(zNumStr, 2)
                ElseIf (Len(zNumStr) = 1) Then
                    zTemp = Right(zNumStr, 1)
                Else
                    zTemp = Right(zNumStr, 3)
                End If
            End If
            zStrTemp = ""
            If Val(zTemp) > 99 Then
                zStrTemp = word_GetH(Right(zTemp, 3), zBp)
                If Right(Trim(xStrTemp), 3) <> "Lac" Then
                zBp = zBp + 1
                End If
            ElseIf Val(zTemp) <= 99 And Val(zTemp) > 9 Then
                zStrTemp = word_GetT(Right(zTemp, 2))
            ElseIf Val(zTemp) < 10 Then
                zStrTemp = word_GetD(Right(zTemp, 2))
            End If
            If zStrTemp <> "" Then
                zRStr = zStrTemp & zArrPlace(zP) & zRStr
            End If
            If zP = 2 Then
                If Len(zNumStr) = 1 Then
                    zNumStr = ""
                Else
                    zNumStr = Left(zNumStr, Len(zNumStr) - 2)
                End If
           ElseIf zP = 3 Then
                If Len(zNumStr) >= 3 Then
                     zNumStr = Left(zNumStr, Len(zNumStr) - 2)
                Else
                    zNumStr = ""
                End If
            ElseIf zP = 4 Then
              zNumStr = ""
        Else
            If Len(zNumStr) <= 2 Then
            zNumStr = ""
        Else
            zNumStr = Left(zNumStr, Len(zNumStr) - 3)
            End If
        End If
            zP = zP + 1
    Loop
        If zRStr = "" Then
           zRStr = "No Rupees"
        Else
           zRStr = " Rupees " & zRStr
        End If
        If zRStr_Paisas <> "" Then
           zRStr_Paisas = " and " & zRStr_Paisas & " Paisas"
        End If
        word = zRStr & zRStr_Paisas & " Only"
        End Function
    Function word_GetH(zStrH As String, zBp As Integer)
    Dim zRStr As String
    If Val(zStrH) < 1 Then
        word_GetH = ""
        Exit Function
        'Converts a Number from 100 to 999 into Word
    Else
       zStrH = Right("000" & zStrH, 3)
       If Mid(zStrH, 1, 1) <> "0" Then
            If (zBp > 0) Then
             zRStr = word_GetD(Mid(zStrH, 1, 1)) & " Lac "
            Else
             zRStr = word_GetD(Mid(zStrH, 1, 1)) & " Hundred "
            End If
        End If
        If Mid(zStrH, 2, 1) <> "0" Then
            zRStr = zRStr & word_GetT(Mid(zStrH, 2))
        Else
            zRStr = zRStr & word_GetD(Mid(zStrH, 3))
        End If
    End If
        word_GetH = zRStr
    End Function
    Function word_GetT(zTStr As String)
        Dim zTArr1 As Variant
        Dim zTArr2 As Variant
        Dim zRStr As String
        'Converts a Number from 10 to 19 into Word
        
        zTArr1 = Array("Ten", "Eleven", "Twelve", "Thirteen", "Fourteen", "Fifteen", "Sixteen", "Seventeen", "Eighteen", "Nineteen")
        'Converts a Number from 20 to 99 into Word
        
        zTArr2 = Array("", "Twenty", "Thirty", "Forty", "Fifty", "Sixty", "Seventy", "Eighty", "Ninety")
        Result = ""
        If Val(Left(zTStr, 1)) = 1 Then
            zRStr = zTArr1(Val(Mid(zTStr, 2, 1)))
        Else
            If Val(Left(zTStr, 1)) > 0 Then
                zRStr = zTArr2(Val(Left(zTStr, 1)) - 1)
            End If
            zRStr = zRStr & word_GetD(Right(zTStr, 1))
        End If
          word_GetT = zRStr
    End Function
    Function word_GetD(zDStr As String)
    Dim zArr_1() As Variant
    'Converts a Number from 1 to 9 into Word
    
        zArr_1 = Array(" One", " Two", " Three", " Four", " Five", " Six", " Seven", " Eight", " Nine", "")
        If Val(zDStr) > 0 Then
            word_GetD = zArr_1(Val(zDStr) - 1)
        Else
            word_GetD = ""
        End If
    End Function
    

    Regards
    ExcelDemy

  39. Hello,

    Thanks for reaching out to us.

    First, remember that rules and instructions for interest calculation after garnishment order vary among countries and states. Next, post-judgment interest accrues only on the unpaid balance of the judgment.

    However, to calculate interest if the judgment was turned into a garnishment, you can follow the steps below.
    1. Take your judgment amount and deduct the amount of garnishment.
    2. Multiply it by your post-judgment rate (%).
    3. Take the total and divide it by 365 (the number of days in a year).
    4. With the amount of post-judgment interest per day (in step 3), multiply it by the number of days from your date of judgment to the date you file your execution.

    Simply, use the following formula to calculate interest if the judgment was turned into a garnishment:
    Interest after Garnishment = (Judgment Amount – Garnished Amount) ( Interest Rate / 365) Interim Days

    Thanks again for your thoughtful comments, especially the points you made about garnishment. It adds valuable perspective to our discussion.

    Regards,
    Abdullah Al Masud,
    ExcelDemy Team

  40. Hello Muhammad Asif,

    You are most welcome.

    Regards
    ExcelDemy

  41. Hello Joseph Jabatie,

    You are welcome. You can get the notes or Excel workbook from the Download section.

    Regards
    ExcelDemy

  42. Hello Mohammed.

    Thanks for your appreciation. Our content is completely free for our users learning but don’t use it for your business purpose without proper agreement.

    Regards
    ExcelDemy

  43. Hello Mohamed Sufi,

    You are most welcome.

    Regards
    ExcelDemy

  44. Hello Jude Ranby,

    Here, the first methods Linking Existing Table on Another Sheet in Excel is duplicating the source table.

    Here, I’m attaching a video for understanding.

    Regards
    ExcelDemy

  45. Hello Smn,

    Formula of Exercise -5: =AND(G102=”Astro”,OR(C102=”Laptop”,C102=”Mobile Phone”)) is used to check multiple conditions using the AND and OR logical functions.

    Here,

    G102=”Astro”: It checks the value of G102 is equal to “Astro” or not.

    OR(C102=”Laptop”,C102=”Mobile Phone”): It checks the value of cell C102 is equal to either “Laptop” or “Mobile Phone”. Here, the OR function will return TRUE if any of the conditions are TRUE.

    AND(G102=”Astro”, OR(C102=”Laptop”, C102=”Mobile Phone”)): Here, the AND function combines the two conditions. It will return TRUE only if both/two conditions are TRUE.

    Exercise-5 solution

    Regards
    ExcelDemy

  46. Hello M-curious,

    To do a conditional formatting follow the steps of method 1. Instead of using custom option from format cells, you can use the Alignment options.
    Go to Format cells dialog box then from Alignment select any select any Alignments of your choice.

    Alignments

    Regards
    ExcelDemy

  47. Hello Dear,

    You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  48. Dear Anthonia Aniekule,

    You are most welcome.

    Regards
    ExcelDemy

  49. Hello Bob Leslie,

    You will get Break Even Analysis Template template in this article.

    Regards
    ExcelDemy

  50. Hello Oscar,

    Glad to hear that our blogs are helping professionals.

    Regards
    ExcelDemy

  51. Hello IDD,

    If you want real-time synchronization between the Excel file on your computer and Google Sheets, you can use the Google Drive desktop app.
    1. Download and install the Google Drive app on your computer.
    2. Sign in with the same Google account used to upload the Excel file.
    3. Copy or move the Excel file to the Google Drive folder on your computer.
    Open the Excel file from the Desktop App of Drive. Then, any changes made to the file on your computer will be automatically synced with Google Drive, and subsequently, with Google Sheets.

    Finally, open the google sheets from the Drive. You will get the updated Excel file.

    Regards
    ExcelDemy

  52. Dear Tony

    You are most welcome.

    Regards
    ExcelDemy

  53. Dear Yasin,

    You are most welcome.

    Regards
    ExcelDemy

  54. Dear OppaPanda,

    You are most welcome.

    Regards
    ExcelDemy

  55. Hello Thomas,

    Thanks for your appreciation. We are working on it.

    Regards
    ExcelDemy

  56. Dear AKhtar Khilji,

    I hope this message finds you well too. Thank you very much for your kind words and your interest in using the training material from my blog for your nonprofit Excel training program. I’m thrilled to hear that you found the content helpful and that it will be used to empower the youth of marginalized communities in Pakistan.

    I’m more than happy to grant you permission to utilize the exercises from the blog for your educational initiative. Please feel free to mention “ExcelDemy” along with the web address to provide proper attribution. It’s wonderful to know that the material will be shared with the trainees to enhance their learning experience.

    If you have any specific requests or need further assistance with anything related to the training material, please don’t hesitate to reach out. I’m here to support your efforts in any way I can.

    Wishing you great success with your Excel training program and the empowerment of the youth in marginalized communities.

    Best regards,
    ExcelDemy

  57. Hello Rahul,

    You are most welcome.

    Regards
    ExcelDemy

  58. Hello AJ,

    You are most welcome.

    Regards
    ExcelDemy

  59. Hello Ankur Vaish,

    Thanks for your suggestions.

  60. Hello Sam Arthur,

    You are most welcome.

    Regards
    ExcelDemy

  61. Dear John Summers,

    You are most welcome. Your appreciation means a lot to us to write such technical and informative article in future.

    Regards
    ExcelDemy

  62. Hello Tiffany A Snyder,

    You are most welcome.

    Regards
    ExcelDemy

  63. Hello Earlington Etienne,

    You are most welcome.

    Regards
    ExcelDemy

  64. Hello Loni,

    You are most welcome.

    Regards
    ExcelDemy

  65. Hello,

    You are most welcome.

    Regards
    ExcelDemy

  66. Hello Jane Wanjiku,

    You are most welcome.

    Regards
    ExcelDemy

  67. Hello Sandra Merlo,

    You are most welcome.

    Regards
    ExcelDemy

  68. Hello Gallienus,

    You are most welcome.

    Regards
    ExcelDemy

  69. Hello John,

    You are most welcome.

    Regards
    ExcelDemy

  70. Dear Margaret,

    You are welcome.

    Regards
    ExcelDemy

  71. Hello Akram Siddique,
    Here, in the formula : =WEEKDAY(B5,11)
    11 means – Numbers 1 (Monday) through 7 (Sunday). Here the weeks starts from Monday. So it will count the days of week from Monday and the integer value will be 1, Tuesday (2) and so on.

    day of weeks

    Regards
    ExcelDemy

  72. Hello Noelle,

    To highlight the entire row, insert the following formula: =$C5 < TODAY()

    Formula

    In applies to select the rows
    Applies to

    Regards
    ExcelDemy

  73. Dear Daniela Vognar,

    You are most welcome.

    Regards
    ExcelDemy

  74. Dear Radu Pescaru,

    Sunteți foarte bineveniți.

    Regards
    ExcelDemy

  75. Hello Patricia Pearson,

    You are most welcome.

    Regards
    ExcelDemy

  76. Hello Ehia,

    You are most welcome.

    Regards
    ExcelDemy

  77. Hello

    You are most welcome.

    Regards
    ExcelDemy

  78. Hello Chris,

    You are most welcome.

    Regards
    ExcelDemy

  79. Hello Sirajudeen,

    You are most welcome.

    Regards
    ExcelDemy

  80. Hello Patrick Opiola,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  81. Hello Mardell Daubney,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  82. Hello Dr.M. Veerendra Kumar,

    You are most welcome.

    Regards
    ExcelDemy

  83. Hello Hamed,

    You are most welcome.

    Regards
    ExcelDemy

  84. Hello AJ,

    You are most welcome.

    Regards
    ExcelDemy

  85. Hello Joedel,

    You are most welcome.

    Regards
    ExcelDemy

  86. Hello Abdul Kader Osman,

    You are most welcome.

    Regards
    ExcelDemy

  87. Dear Saiful Amin,

    You are most welcome.

    Regards
    ExcelDemy

  88. Hello Abdrman,

    You are most welcome.

    Regards
    ExcelDemy

  89. Hello Nick,

    You are most welcome.

    Regards
    ExcelDemy

  90. Hello Gianluigi,

    You are most welcome.

    Regards
    ExcelDemy

  91. Hello JC,

    You are most welcome.

    Regards
    ExcelDemy

  92. Hello JC,

    You are most welcome.

    Regards
    ExcelDemy

  93. Hello Andrii,

    You are welcome.

    Regards
    ExcelDemy

  94. Hello Syed Minhaj,

    You are most welcome.

    Regards
    ExcelDemy

  95. Hello Peter,

    So kind of you.

    Regards
    ExcelDemy

  96. Hello Nurit,

    You are most welcome.

    Regards
    ExcelDemy

  97. Hello Ava,

    Thanks

  98. Hello Tamiko,

    You are most welcome.

    Regards
    ExcelDemy

  99. Hello Huongpt,

    You are welcome.

    Regards
    ExcelDemy

  100. Hello Brenda Gale Austin-Sanders,

    You are most welcome.

    Regards
    ExcelDemy

  101. Dear Mario,

    You are most welcome.

    Regards
    ExcelDemy

  102. Hello Amanz,

    We shared our ideas with you in your ExcelDemy Forum post.

  103. Hello Adam Ingleton,

    You are most welcome.

    Regards
    ExcelDemy

  104. Hello Ani,

    You are most welcome.

    Regards
    ExcelDemy

  105. Hello Vijiaselvam Nayagam,

    You are most welcome.

    Regards
    ExcelDemy

  106. Hello Mohammad,

    You are welcome.

    Regards
    ExcelDemy

  107. Hello Suzie,

    Glad to hear that our solution helped you.

    Regards
    ExcelDemy

  108. Hello Romeo Nyi,

    You are most welcome.

    Regards
    ExcelDemy

  109. Dear Minzitia Lawrence,

    You are welcome.

    Regards
    ExcelDemy

  110. Hello Juan,

    You are most welcome.

    Regards
    ExcelDemy

  111. Dear Kagiso,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  112. Hello Azreim,

    You are most welcome.

    Regards
    ExcelDemy

  113. Thanks for your appreciation.

    Regards
    ExcelDemy

  114. Hello Lee G,

    You are most welcome.

    Regards
    ExcelDemy

  115. Hello Tanveer,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  116. Hello Mian Muhammad Saleem,

    You are most welcome.

    Regards
    ExcelDemy

  117. Hello JD,

    You are most welcome.

    Regards
    ExcelDemy

  118. Hello Eduardo,

    You are welcome.

    Regards
    ExcelDemy

  119. Dear Sam,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  120. Hello Mongwongprue Marma,

    You are welcome.

    Regards
    ExcelDemy

  121. Hello Calin,

    You are most welcome.

    Regards
    ExcelDemy

  122. Hello Adam,

    Thanks for your appreciation. You are most welcome.

    Regards
    ExcelDemy

  123. Hello Ali,

    Thanks for your appreciation. You are most welcome.

    Regards
    ExcelDemy

  124. Hello Dawood,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  125. Hello Eduardo,

    Kindly share your Excel File and images in ExcelDemy Forum.

    Regards
    ExcelDemy

  126. Hello Daniel Woods,

    To make problem sharing easier we launched ExcelDemy Forum, so that you can upload Excel Files and images of your problem. You can share your workbook in ExcelDemy Forum our expert team will reach out to you.

    Regards
    ExcelDemy

  127. Hello Daniel Woods,

    To make problem sharing easier we launched ExcelDemy Forum, so that you can upload Excel Files and images of your problem. You can share your workbook in ExcelDemy Forum our expert team will reach out to you.

    Regards
    ExcelDemy

  128. Hello Abishek,

    You are most welcome.

    Regards
    ExcelDemy

  129. Hello David,

    Thanks for your valuable suggestions.

    Regards
    ExcelDemy

  130. Hello Mike Longoria,

    You are most welcome.

    Regards
    ExcelDemy

  131. Hello Z Thomas,

    You are most welcome.

    Regards
    ExcelDemy

  132. Dear Andrija,

    You are most welcome.

    Regards
    ExcelDemy

  133. Hello Mohammed,

    Kindly share the issues you are facing while using the Excel file in the comment box. In case you need to share images, Excel file, you also can post your problem in ExcelDemy Forum.

    Regards
    ExcelDemy

  134. Hello Syifaa’ Mustafa,

    To get the Developer tab follow the steps mentioned in the article Display the Developer tab in Excel. Then you can use it to create Tooltip.

    Regards
    ExcelDemy

  135. Hello Selam,

    You are most welcome.

    Regards
    ExcelDemy

  136. Hello DanJ,

    You are most welcome.

    Regards
    ExcelDemy

  137. Hello Matt S,

    You are most welcome.

    Regards
    ExcelDemy

  138. Hello Odedele Olufemi,

    You are welcome.

    Regards
    ExcelDemy

  139. Hello Joel,

    You are most welcome.

    Regards
    ExcelDemy

  140. Hello Chanyalew,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  141. Hello Lynn,

    You are most welcome.

    Regards
    ExcelDemy

  142. Hello Nasir Ahmed,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  143. Dear Anon,

    You are most welcome.

    Regards
    ExcelDemy

  144. Hello Vickie Addo,

    We have given the answers of 100 questions in our Excel File, which is given in the Download Practice Workbook Section. As these questions are given to test your skills it won’t be helpful to check the answer immediately. A gif is given how you can test your skills at the end. Please download the Excel File and test you skills then see the answers.

    Regards
    ExcelDemy

  145. Hello Venkatesh,

    You are most welcome.

    Regards
    ExcelDemy

  146. Dear Alexandar P,

    You are most welcome.

    Regards
    ExcelDemy

  147. Hello Naziom,

    You are most welcome.

    Regards
    ExcelDemy

  148. Hello Viraltecho,

    You are most welcome.

    Regards
    ExcelDemy

  149. Hello Joel,

    You are most welcome.

    Regards
    ExcelDemy

  150. Hello,

    You are most welcome.

    Regards
    ExcelDemy

  151. Hello Suhaili,

    You don’t need to worry about payment. If you want any read-to-use template kindly send your requirements using [email protected] email.

    Regards
    ExcelDemy

  152. Dear Dave,

    You are most welcome.

    Regards
    ExcelDemy

  153. Dear Komal Thakur,

    You are most welcome.

    Regards
    ExcelDemy

  154. Hello Samia,

    In the Download Practice Workbook section, you will get the dataset used in the article.

    Regards
    ExcelDemy

  155. Hello Nafez,

    You are most welcome and thanks for you invitation to visit Qatar.

    Regards
    ExcelDemy

  156. Hello May,

    The “Developer Tab” option is missing in default Excel versions. You can enable it from Excel Options. By following this article Display the Developer Tab you can enable it easily.

    Regards
    ExcelDemy

  157. Dear Laurie,

    You are most welcome.

    Regards
    ExcelDemy

  158. Dear Sovereign,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  159. Hello Sagar,

    You will get the solutions in the Excel file, which is given in the Download Practice workbook Section.

    Regards
    ExcelDemy

  160. Dear Anusha Uppuganti,

    You are most welcome. We are so glad that our article explanation helped you.

    Regards
    ExcelDemy

  161. Dear PK,

    Thanks for your appreciation. You are most welcome.

    Regards
    ExcelDemy

  162. Hello Tsegay Gebreselasie,

    Our aim is giving you the best Excel-related content like this.

    Regards
    ExcelDemy

  163. Dear Mark,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  164. Hello Rolan,

    Thanks for your suggestion. Article is updated.

  165. Hello Damien,

    From our Download Practice Workbook section, you will get the Excel file.

    If you face any difficulties after downloading the above file, follow this article to Enable Macros but Not Working

    Regards
    ExcelDemy

  166. Hello Taiwo,

    All the solution are available in the Excel Practice file section.

    We used this formula to get discount amount: =F5*IF(D5<1,0.03,0.05)

    Comment reply

    Regards
    ExcelDemy

  167. Hi viralTecho

    Thanks for your appreciation.

    Regards
    ExcelDemy

  168. Hello James Ward,

    To run the code from Excel you can follow these steps:
    Developer tab >> Macros >> Select any Sub Procedure from the list

    Comment reply

    Regards
    ExcelDemy

  169. Hello Hugh Richards,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  170. Dear Noe Albarran,

    You are most welcome.

    Regards
    ExcelDEmy

  171. Dear Yuan,

    Thanks for the suggestions. The code is updated you can check it now.

    Regards
    ExcelDemy

  172. Dear Amir

    You have to use either the combined formula or the vba code. Because converting number to words maintaing the place vaule is not possible by simple formula.

    Regards
    ExcelDemy

  173. Dear Ian Fisher,

    You are most welcome.

    Regards
    ExcelDemy

  174. Hello Viraltecho,

    You are most welcome.

    Regards
    ExcelDemy

  175. Hello Viraltecho,

    You are most welcome.

    Regards
    ExcelDemy

  176. Dear Roberto,

    You are most welcome.

    Regards
    ExcelDemy

  177. Dear Aubrey

    You are most welcome. Your appreciation means a lot to us.

    Regards
    ExcelDemy

  178. Dear Dilip Paunikar

    You are most welcome.

    Regards
    ExcelDemy

  179. Dear Soumendra

    You are most welcome.

    Regards
    ExcelDemy

  180. Hello Manwesh,

    You can state your problem in the comment section or in our ExcelDemy Forum.

    Regards
    ExcelDemy

  181. Dear Ashab,

    We do have a YouTube channel named ExcelDemy

    Regards
    ExcelDemy

  182. Dear Evangeline,

    Thanks for your appreciation. Our experienced writers write these questions after doing a complete research about the topic.

    Regards
    ExcelDemy

  183. Dear Jason,

    You are most welcome.

    Regards
    ExcelDemy

  184. Dear Ryan,

    Glad to hear that our article helped you.

    Regards
    ExcelDemy

  185. Dear Endashaw Balcha,

    To know more about excel formula you can explore our Excel Formulas category. From here you will get practical use of different formulas in different fields.

    Regards
    ExcelDemy

  186. Dear Raf,

    You are most welcome.

    Regards
    ExcelDemy

  187. Hello Muhammad Amin,

    Good to hear that. To get more helpful contents explore our site.

    Regards
    ExcelDemy

  188. Dear Jess,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  189. Dear Jimmy,

    You are most welcome.

    Regards
    ExcelDemy

  190. Hello y2mate,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  191. Dear ytMp3,

    Thank you so much.

    Regards
    ExcelDemy

  192. Dear Martin Carrion,

    You are most welcome.

    Regards
    ExcelDemy

  193. Dear Dina,

    Thank you so much for your appreciation.

    Regards
    ExcelDemy

  194. Dear Navini,

    You are most welcome.

    Regards
    ExcelDemy

  195. Dear Gopi Sahu,

    Thanks for reaching out to us. You will get various types of WFM related articles here Excel Solver

    If you need solution of any specific topic kindly comment down below.

    Regards
    ExcelDemy

  196. Dear Justice,

    You are most welcome.

    Regards
    ExcelDemy

  197. Dear Merry,

    You are most welcome.

    Regards
    ExcelDemy

  198. Dear Karen,

    You are most welcome.

    Regards
    ExcelDemy

  199. Hi Putul ch. Borah,

    Yes, you can do it by following the mentioned steps.

  200. Dear Tiago,

    You are most welcome.

    Regards
    ExcelDemy

  201. Dera Ashok,

    You are most welcome.

    Regards
    ExcelDemy

  202. Dear Foysal,

    You are most welcome.

    Regards
    ExcelDemy

  203. Dear kinyapreen,

    To get virtual lessons you can follow our youtube channel Youtube Channel

    Regards
    ExcelDemy

  204. Hello BART,

    It is possible to add a VB line of code to run the selection change code only when you click the tab of the worksheet called “index.” To achieve this, you can use the Worksheet_Activate event in the code module of the “index” worksheet. Here’s the code.

    Private Sub Worksheet_Activate()
        Dim mVCount As Integer
        Dim mHCount As Integer
        Dim mVBreak As VPageBreak
        Dim mHBreak As HPageBreak
        Dim mNumPage As Integer
        
        mHCount = 1
        mVCount = 1
        
        If ActiveSheet.PageSetup.Order = xlDownThenOver Then
            mHCount = ActiveSheet.HPageBreaks.Count + 1
        Else
            mVCount = ActiveSheet.VPageBreaks.Count + 1
        End If
        
        mNumPage = 1
        
        For Each mVBreak In ActiveSheet.VPageBreaks
            If mVBreak.Location.Column > ActiveCell.Column Then Exit For
            mNumPage = mNumPage + mHCount
        Next
        
        For Each mHBreak In ActiveSheet.HPageBreaks
            If mHBreak.Location.Row > ActiveCell.Row Then Exit For
            mNumPage = mNumPage + mVCount
        Next
        
        ThisWorkbook.Worksheets("Worksheet 1").Range("I2").Value = "Page " & mNumPage & " of " & Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
        ThisWorkbook.Worksheets("Worksheet 3").Range("C5").Value = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
    End Sub
    

    Regards
    Alif Bin Hussain

  205. Dear,

    You are most welcome.

    Regards
    ExcelDemy

  206. Dear Bart,

    You are most welcome. Sure, you can inform us.

    Regards
    ExcelDemy

  207. Dear Najeeburk,

    You are most welcome.

    Regards
    ExcelDemy

  208. Dear Danny Van Straten,

    If you need any types of customized templates you may contact us through [email protected]
    We have a expert team to create any types of professional templates.

    Regards
    ExcelDemy

  209. Hello Yaojm,

    Thanks for your suggestions. Here we focused on the comparison/difference of VLOOKUP and XLOOKUPp that’s why we didn’t improvised the use of VLOOKUP.

    Regards
    ExcelDemy

  210. Hello Pankaj,

    You are welcome.

    Regards
    ExcelDemy

  211. Dear Charlotte,

    You are most welcome.

    Regards
    ExcelDemy

  212. Dear Mustafa,

    You are most welcome.

    Regards
    ExcelDemy

  213. Hello Abubakar,

    You are most welcome. We hope so you will be able to create an interim certificate template following these steps.

    Regards
    ExcelDemy

  214. Dear B,

    You are welcome.

    Regards
    ExcelDemy

  215. Dear Akash,

    You are most welcome.

    Regards
    ExcelDemy

  216. Dear Carl,

    You are most welcome.

    Regards
    ExcelDemy

  217. Hello Dear,

    You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  218. Dear Macel Williams,

    To customize any templates you can contact with us via this mail problem @exceldemy.com

    Regards
    ExcelDemy

  219. Dear Macel Williams,

    To customize any templates you can contact with us via this mail problem @exceldemy.com

    Regards
    ExcelDemy

  220. Dear Qasim,

    Thanks for your suggestions we have updated our Exercise 3 you can check it now.

    Regards
    ExcelDemy

  221. Dear Kenny H,

    This Email address is valid but if you face any problem you can post your problem in our ExcelDemy Forum.

    Regards
    ExcelDemy

  222. Dear Nikhil Pandey,

    You will get all the solutions in the workbook’s Solution sheet. Here I’m giving you the query answer for your understanding.

    The Formula is : =WEEKDAY(B5,11)

    Get-Weekday

    Regards
    ExcelDemy

  223. Dear Nikhil Pandey,

    You will get the solution sheet in the Download Practice Files section. Download the workbook there in Solution sheet you will get all the solutions. You you can get the workbook from this link Solution Sheet

    Regards
    ExcelDemy

  224. Dear Aiden,

    Yes you can do that.

    Regards
    ExcelDemy

  225. Dear Macel,

    You are welcome.

    Regards
    ExcelDemy

  226. Dear Marc,

    You are welcome.

    Regards
    ExcelDemy

  227. Dear Kim,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  228. Dear Prakash Tulsiani,

    You are most welcome.

    Regards
    ExcelDemy

  229. Dear Kay,

    To get a customized templates you can contact with us through this Email: [email protected]

    Regards
    ExcelDemy

  230. Hello Dear,

    You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  231. Dear Nadew w/yesus,

    You are most welcome.

    Regards
    ExcelDemy

  232. Dear Dr,

    You are most welcome.

    Regards
    ExcelDemy

  233. Dear Adil Ahmed,

    You are most welcome.

    Regards
    ExcelDemy

  234. Dear Macel Williams,

    You are most welcome.

    Regards
    ExcelDemy

  235. Hello Dear,

    You can download the Cheat Sheet free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  236. Dear Isaac,

    You are most welcome.

    Regards
    ExcelDemy

  237. Dear MADI,
    Thank you for following our article.
    To split into sheets based on certain row conditions, we have to enter an IF condition that checks if the row is of a certain colour. Here, I have added the code to do this.

    Sub SplitSheetByGreenColor()
        Dim Rng As Range
        Dim xRow As Range
        Dim SplitRow As Integer
        Dim xSheet As Worksheet
        Dim i As Integer
        Dim resizeCount As Integer
        
        On Error Resume Next
        xTitleId = "ExcelSplit"
        Set Rng = Application.Selection
        Set Rng = Application.InputBox("Range", xTitleId, Rng.Address, Type:=8)
        SplitRow = Application.InputBox("Row Number Split", xTitleId, 5, Type:=1)
        Set xSheet = Rng.Parent
        Set xRow = Rng.Rows(1)
        Application.ScreenUpdating = False
        
        For i = 1 To Rng.Rows.Count Step SplitRow
            resizeCount = SplitRow
            If (Rng.Rows.Count - xRow.Row + 1) < SplitRow Then resizeCount = Rng.Rows.Count - xRow.Row + 1
            
            If xRow.Cells(1).Interior.Color = RGB(0, 255, 0) Then
                xRow.Resize(resizeCount).Copy
                Application.Worksheets.Add after:=Application.Worksheets(Application.Worksheets.Count)
                Application.ActiveSheet.Range("A1").PasteSpecial
            End If
            
            For j = 2 To Worksheets.Count
            Worksheets(j).Name = "Green" & j - 1
            Next j
    
            Set xRow = xRow.Offset(SplitRow)
        Next
        
        Application.CutCopyMode = False
        Application.ScreenUpdating = True
    End Sub

    This code checks if the interior colour of the first cell in each row of the selected range is Green(RGB(0,255,0)). The entire row is copied and pasted into a new sheet if rows meet the condition. You can alter this colour condition according to your need.

    Regards
    Priti

  238. Dear Sara,

    You will find the solutions in the Excel file which is given in Download Practice Workbook section.

    Regards
    ExcelDemy

  239. Dear Sakshi,

    You are most welcome.

    Regards
    ExcelDemy

  240. Dear Md. Morshed Alam,

    You are most welcome.

    Regards
    ExcelDemy

  241. Dear Alex,

    Thanks for your feedback.

    Regards
    Exceldemy

  242. Dear Paresh Kanti Paul,

    We are glad to hear that.

    Regards
    ExcelDemy

  243. Hello Dear,

    You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  244. Dear Sushil,

    You are most welcome.

    Regards
    ExcelDemy

  245. Dear Duncan R Walk,

    You are most welcome.

    Regards
    ExcelDemy

  246. Dear Bolajoko Olufemi,

    You will get all resources related to Data Analysis here All About Data Analysis. We are planning to launch courses as soon as possible.

    Regards
    ExcelDemy

  247. Dear Ronald,

    You are most welcome.

    Regards
    ExcelDemy

  248. Dear Ronhat Minmin,

    If you want to get the Excel File, you can download it from Download Practice Workbook

    Regards
    ExcelDemy

  249. Dear Ebrahim Ahmadi,

    You are welcome.

    Regards
    ExcelDemy

  250. Hello Dear,

    You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  251. Dear Lin Giralt,

    You are most welcome.

    Regards
    ExcelDemy

  252. Dear Khin Soe,

    You are most welcome.

    Regards
    ExcelDemy

  253. Dear Tha’ir,

    You are most welcome.

    Regards
    ExcelDemy

  254. Dear Mohamad,

    Thanks for your appreciation

    Regards
    ExcelDemy

  255. Dear Minhajul,

    You are most welcome.

    Regards
    ExcelDemy

  256. Dear Sandeep Bhattacharjee,

    You are most welcome and thanks for your appreciation.

    Regards
    ExcelDemy

  257. Hello Sujay Jain,

    You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the Top 100 MCQ of Excel section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  258. Dear S Roy,

    You are most welcome.

    Regards
    ExcelDemy

  259. Hi Kazem,

    You are welcome.

    Regards
    ExcelDemy

  260. Dear Lana,

    You are most welcome.

    Regards
    ExcelDemy

  261. Dear Seamus Madden,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  262. Hi Ndonwi,

    Thanks

  263. Dera Merc,

    You are most welcome.

    Regards
    ExcelDemy

  264. Dear Joanna,

    You are most welcome.

    Regards
    ExcelDemy

  265. Dear Richard,

    You are most welcome.

    Regards
    ExcelDemy

  266. Dear Andrei,

    These functions are available in WPS office.

    Regards
    ExcelDemy

  267. Dear Kapil,

    You are most welcome.

    Regards
    ExcelDemy

  268. Dear Tommy Fuifui,

    You are most welcome.

    Regards
    ExcelDemy

  269. Dear Excel Nob,

    You are most welcome.

    Regards
    ExcelDemy

  270. Dear Car,

    You are most welcome.

    Regards
    ExcelDemy

  271. Dear Jamie,

    You are most welcome.

    Regards
    ExcelDemy

  272. Dear Anitelleth,

    You are most welcome.

    Regards
    ExcelDemy

  273. Dear Anitelleth,

    You are most welcome.

    Regards
    ExcelDemy

  274. Dear Kay,

    You are welcome.

    Regards
    ExcelDemy

  275. Dear Pirooz Rahimi,

    You are most welcome and thanks for your appreciation.

    Regards
    ExcelDemy

  276. Dear Abel,

    Thanks for your appreciation. You are most welcome.

    Regards
    ExcelDemy

  277. Dear Kh Paydar,

    You are most welcome.

    Regards
    ExcelDemy

  278. Dear Joris,

    You are most welcome. We are glad to hear that.

    Regards
    ExcelDemy

  279. Dear Raja,

    You are most welcome.

    Regards
    ExcelDemy

  280. Dear Kapil,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  281. Dear Polepeddi Sasidhar,

    We are glad to hear that.

    Regards
    ExcelDemy

  282. Hello Silpa,

    You can download the Excel and PDF files free of cost just by providing your valid email address. To get the files go to the “Download Excel Formulas Cheat Sheet PDF & Excel Files” section of this post and enter your email address. Then check your email immediately after to get the download links.

    Best Regards
    ExcelDemy

  283. Dear Jidith Savidge,

    You are most welcome.

    Regards
    ExcelDemy

  284. Dear Ajij Nadaf,

    We will love to give you suggestions. kindly share your problem.

    Regards
    ExcelDemy

  285. Good day, Daniel,

    The issue you’re having might be because your workbook’s data range differs from the data range specified in our code.

    Change the data range according to your worksheet.

    This might be the solution to your issue. I’d appreciate it if you could send me the worksheet you’re working on so that I can better understand your issue and give you an exact solution.

    Regards
    Sakibul Hasan Nahid | ExcelDemy Team

  286. Hey Philip,

    Thanks for your response. You can use the SORT and FILTER functions along with the LARGE function to solve your problem.
    Here’s the practice sheet we used. You can check it out for a better understanding.
    SORT-FILTER.xlsx
    You can also check out this article for more detailed explanations.
    https://www.exceldemy.com/excel-top-10-list-with-duplicates/

    Regards
    Hassan Shuvo| ExcelDemy Team

  287. Hello Chandan,

    Thanks for commenting. If I’m not wrong, you want to match the dataset like the one below.

    Select the entire dataset without the heading then go to conditional formatting >> New Rule

    Then select “Use a formula to determine which cells to format.”
    In the formula bar, enter the following formula:
    =AND(A3<>B3,C3<>B3)
    Press OK

    Here, “A3” represents the cell containing the customer name, “B3” represents the cell containing the ID name, and “C3” represents the cell containing the real name. You can adjust the cell references based on your data.
    Choose the formatting option that you want to use for the highlighted rows. For example, we took light green color here for highlighting.
    The final outcome will look like the image below.

    I hope this answer will help you to identify matched names. Please let us know if you have any other queries. Also, you can post your Excel-related problem in ExcelDemy Forum with images or Excel workbooks.

    Regards
    Mizbahul Abedin | ExcelDemy Team

  288. Dear MD. KAMAL HOSSAIN,

    To obtain your required format please follow the following simple steps:
    From your Excel Workbook, press ALT + F11 to open Visual Basic Editor.
    Insert a module.
    Paste the following code:

    Function NumberToWords(ByVal Number As Long) As String
        Dim Ones() As String
        Dim Tens() As String
        Dim Group() As String
        Dim Result As String
        
        Ones = Split("One,Two,Three,Four,Five,Six,Seven,Eight,Nine", ",")
        Tens = Split("Ten,Eleven,Twelve,Thirteen,Fourteen,Fifteen,Sixteen,Seventeen,Eighteen,Nineteen", ",")
        Group = Split("Twenty,Thirty,Forty,Fifty,Sixty,Seventy,Eighty,Ninety", ",")
        
        If Number = 0 Then ' Handle zero
            Result = ""
        ElseIf Number < 10 Then
            Result = Ones(Number - 1)
        ElseIf Number < 20 Then
            Result = Tens(Number - 10)
        ElseIf Number < 100 Then
            If Number Mod 10 = 0 Then ' Handle multiples of 10
                Result = Group(Int(Number / 10) - 2)
            Else
                Result = Group(Int(Number / 10) - 2) & " " & Ones(Number Mod 10 - 1)
            End If
        ElseIf Number < 1000 Then
            Result = Ones(Int(Number / 100) - 1) & " Hundred " & NumberToWords(Number Mod 100)
        ElseIf Number < 1000000 Then
            Result = NumberToWords(Int(Number / 1000)) & " Thousand " & NumberToWords(Number Mod 1000)
        ElseIf Number < 1000000000 Then
            Result = NumberToWords(Int(Number / 1000000)) & " Million " & NumberToWords(Number Mod 1000000)
        Else
            Result = "Number is too large."
        End If
        
        NumberToWords = Trim(Result)
    End Function

    Now, return to your worksheet. Type in the following formula in the cell where you require the output and press Enter key.
    =NumberToWords(B5) & ” Taka Only”
    Here, B5 indicates the reference of the cell where you have the input number.

    converting numbers to words

    I hope this solution will be sufficient for your requirements. Let us know your feedback.

    Regards,
    ExcelDemy

  289. Dear Rich Saunders,

    Query 1: The method 7 works just fine. If you write March in F4, you will get the values for that month as well.

    Query 2: The formula is universal for any Excel version. If you write the formula in any cell the formula will get you the entire row value for the name you will write in the F4 cell. For example, if you write “Nathan” in F4 cell and paste the formula in the A1 cell then the formula will write the values of the entire row( B8:D8) in the A1:A3 range.
    Yes, we should have mentioned the Ctrl+Shift+Enter in the article. We will make sure of that in the next articles. As we used Microsoft 365 so it works by pressing Enter. We are sorry for that.

    Regards
    ExcelDemy

  290. Dear Tudor,

    Hope you are doing well. Answer of your questions are given below with explanation.

    1. How can I change the month and day from English to Romanian?

    Select the cell with month and date, cell C7 in our case.
    Right-click with the mouse and select Format Cells.

    monthly staff attendance

    In the Format Cells window, select Romanian (Moldova) under the Locale menu.
    Then, select any type under the Type menu and click the OK button.

    The month and date are changed into Romanian from English. Do the same process for cell E7.

    2. If an employee works on Saturday and/or Sunday, how can I collect those weekend hours separately, in a cell?

    Let’s say the first employee works on Saturday and Sunday for 5 and 6 hours respectively. He works on 4 weekends which you can see in the picture. To sum these values we’ll use the SUMIFS function.
    Apply the formula in any cell where you want the weekend hours, let’s say cell AM11-
    =SUMIFS($F$11:$AJ$11,$F$11:$AJ$11,"<>P",$F$11:$AJ$11,"<>A")

    After pressing Enter you’ll get the total weekend hours. You can use the Fill Handle tool to apply this formula to other employees.

  291. Dear Aspen,

    You are most welcome.

    Regards
    ExcelDemy

  292. Thanks for your suggestions.

  293. Dear Victor,

    You are most welcome.

    Regards
    ExcelDemy

  294. Dear Elizabeth,

    You are most welcome. We are so glad that our article fulfilled your need.

    Regards
    ExcelDemy

  295. Dear Anjli Gupta,

    Answers are given in the Solution sheet of Excel File which is in Download Practice Workbook section.
    Answer sheet

    Soluation-of-Advanced-MCQs-for-Exam

    Regards
    ExcelDemy

  296. Dear HG,

    You are most welcome.

    Regards
    ExcelDemy

  297. Dear Seaunders,

    Thanks for your appreciation. It means a lot to us.

    Regards
    ExcelDemy

  298. Dear Gunawan,

    Thanks for your suggestions. We updated the article. You can check it now.

    Regards
    ExcelDemy

  299. Hi Fake Hidden,

    Thanks for your suggestions. We updated our article so that it fulfills the need of all types of readers. You may check our article now and let us know any kinds of suggestions.

    Regards
    ExcelDemy

  300. Dear Rafi,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  301. Dear Elly,

    Thanks for your appreciation. We re-explained our formulas to make them more understandable. If you find any difficulty now, let us know in the comment section below.

    Regards
    ExcelDemy

  302. Dear Rashmi,

    You are most welcome.

    Regards
    ExcelDemy

  303. Dear Jay Dee,

    That’s good to hear. We are interested to know more from you.

    Regards
    ExcelDemy

  304. Dear Silver,

    You are most welcome.

    Regards
    ExcelDemy

  305. Dear William B,

    You are most welcome.

    Regards
    ExcelDemy

  306. Dear Eugen Safta,

    You are most welcome.

    Regards
    Shamima Sultana | ExcelDemy

  307. Dear Radu,

    Thanks for your suggestion and we appreciate it. We updated the cell range.

  308. Dear Sanket,

    Thanks for your appreciation.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  309. Dear Yar Zar Htun,

    You are most welcome. We are glad that through ExcelDemy you are improving your skill.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  310. Dear Vivasvan,

    You are most welcome. It’s great to know that our article helped you to complete your project.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  311. Dear Bo Thibaut,

    We are willing to do any Excel-related projects. Kindly share your requirements through this Email: [email protected]

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  312. Hi Robert Bakinam,

    Here, you will get the full copy in pdf Marking Result Sheet.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  313. Dear German,

    You are most welcome. To get solutions with detailed explanations, follow ExcelDemy.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  314. Dear Kirsten Wheeler,

    Thanks for your appreciation. To get solutions with detailed explanations, follow ExcelDemy.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  315. Dear NancyM,

    Thanks for your appreciation. To get solutions with detailed explanations, follow ExcelDemy.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  316. Dear CJvW,

    Thanks for your appreciation. To get more helpful content be with ExcelDemy.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  317. Dear Geogre,

    Thanks for your kind attention and suggestion. We updated it.

  318. Dear Michael Gamal Aziz,

    You are most welcome.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  319. Dear Glenn,

    We are glad to hear that. ExcelDemy is trying hard to give you quality content.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  320. Dear Uday Kumar,

    We are working on your problem. We will appreciate you to post your problem in our ExcelDemy Forum.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  321. Dear Ramandeep Kaur,

    Thanks for your appreciation. Sooner we will make another exercise based on Basic and Advanced Formulas.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  322. Dear Datla Srinivas,

    We are working on your requirements. We hope we will come back to you with your expected solutions.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  323. Dear Mody,

    Thanks for your appreciation.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  324. Hello Joanie,

    You are most welcome.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  325. Dear Map,

    Thanks for your appreciation and suggestion. Sooner we will write an article regarding this topic.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  326. Dear Ven Upekkha,

    Thanks for your appreciation.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  327. Dear Rajesh,

    You are welcome.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  328. Dear umit,

    Thanks for your appreciation it means a lot to us.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  329. Hello Zuri,

    Thanks for your suggestion.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  330. Dear Carl,

    Thanks for your appreciation. ExcelDemy is glad to help you.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  331. Dear Sandra Aldridge,

    Thanks for your appreciation it means a lot to us. ExcelDemy is glad to help you.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  332. Dear Micah,

    Thanks for your kind words. ExcelDemy is dedicated to provide solutions to help you.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  333. Dear Mukibul Hasan,

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  334. Dear Shanmuga Raja V S,

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  335. Dear Adam,

    Thanks for your appreciation.

    Shamima | Project Manager | ExcelDemy

  336. Dear Zidane,

    Thanks for your appreciation.

    Shamima | Project Manager | ExcelDemy

  337. Dear Kayla,

    Thanks for your appreciation and we are glad that our Dataset Template helped you.

    Regards
    Shamima | Project Manager | ExcelDemy

  338. Hello Uday Kumar,

    Kindly check the reply to your previous comment. We have given you a non-macro solution.

  339. Dear Forte,

    Thanks for your appreciation. Stay in touch with ExcelDemy to get more helpful content.

    Regards
    Shamima | Project Manager | ExcelDemy

  340. Dear Gilson,

    Thanks for your appreciation. Stay in touch with ExcelDemy to get more helpful content.

    Regards
    Shamima | Project Manager | ExcelDemy

  341. Dear Gerry Conroy,

    You are most welcome.

    Regards
    Shamima | Project Manager | ExcelDemy

  342. Dear Syed Anwar Hussain,

    Thanks for your appreciation.

    Regards
    Shamima | Project Manager | ExcelDemy

  343. Hello, Xzavier!

    For better understanding, we updated the article. Kindly check it now it would be helpful.

    Regards
    ExcelDemy

  344. Hello, An!

    You are most welcome. To get helpful content follow ExcelDemy.

    Regards
    ExcelDemy

  345. Hello, James!

    Your appreciation means a lot to us. To have a more wonderful experience follow ExcelDemy.

    Regards
    ExcelDemy

  346. Hi Rassulsson!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  347. Thanks, Michael, for your query. From your comment, it seems that you want to permanently assign the replacing dataset (denoted by Reprng in the code) instead of taking them in a prompted input box. You can do that by following the steps below.

    1. First, set a Name to the range that contains the Find & Replace with columns (In this case E5:F6). To do that, select the range and type a suitable name on the Name Box. Suppose you give the name “Find_Replace_Array”
    2. Now, open a new module and write the given code of method 1.
    3. Then, on the code, replace the line :

    Set Reprng = Application.InputBox(“Replace with: “, Title, Type:=8)

    With the following line.

    Set Reprng = Range(“Find_Replace_Array”)

    Now, if you run the code, you will only need to select the range where you want to replace values and it will automatically replace the values for you. Here, you will not be required to manually input the address of Find_Replace_Array.

    Hope it does the job for you. If you have any further queries, do let us know. Moreover, if your problem persists, you can post your problem in our Exceldemy Forum along with your Excel file.

  348. Hello, Hamza!

    Thanks for your appreciation. We are glad that our article helped you.

    Regards
    ExcelDemy

  349. Hello, A!

    If your file is protected by using Encrypt with Password feature then it won’t work. We mentioned it in the Things to Remember section.

    Regards
    ExcelDemy

  350. Hello, Nabil sellami!

    Thanks for your appreciation. To get more enjoyable articles stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  351. Hello, JeteMc!

    Welcome, JeteMc. To get more helpful information stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  352. Hello, Helen!

    Thanks for your appreciation. To get more helpful information stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  353. Hi, Irene!

    Thanks for your appreciation. To get more helpful information stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  354. Hi, Elton!

    Thanks for your appreciation. We will try to launch pdf files.

    Regards
    ExcelDemy

  355. Hello, Muhammad Luqman!

    You can download it from Download Excel Formulas Cheat Sheet PDF section.

    Regards
    ExcelDemy

  356. Hi, Bosco!

    Thanks for your appreciation. To get more informative contents stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  357. Hello, Joe Smith!

    The 64-bit version of Excel is not compatible with 32-bit active x controls. To know more about it you can visit this site

    Regards
    ExcelDemy

  358. Hello, Aleksandra!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  359. Hello, Bennie!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  360. Hello, Harry!

    You can download the copy from Download Sample Workbook

    Regards
    ExcelDemy

  361. Hello, Emil Lazar!

    Thanks for your appreciation. Stay in touch with ExcelDemy to get more useful articles.

    Regards
    ExcelDemy

  362. Hi Abishek Sharma!

    If you want the Excel file then you can download it from the Download Practice Workbook section. Or you need other assistance you can comment or send us mail at [email protected]

  363. Hello, Nastaran!

    Thanks for your appreciation. We are glad that our post helped you.

    Regards
    ExcelDemy

  364. Hello, Ruben!

    It’s glad to know that our content is helpful to you. To know more about Excel stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  365. Hello, Tanael Wawe!

    You are welcome. Stay in touch with ExcelDemy to get more helpful content.

    Regards
    ExcelDemy

  366. Hello, Tanael Wawe!

    Thanks for your appreciation. Stay in touch with ExcelDemy to get more helpful content.

    Regards
    ExcelDemy

  367. Hello, Dan!

    Thanks for your appreciation. It means a lot.

    Regards
    ExcelDemy

  368. Hello, Ahnaf!

    You are most welcome. stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  369. Hello, Aleem!

    Thanks for your appreciation. stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  370. Hello, Mohan!

    Thanks for your appreciation. Stay in touch with ExcelDemy for more helpful content.

    Regards
    ExcelDemy

  371. Hello, Many!

    You are most welcome. To get more helpful content with explanations stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  372. Hello, ExcelAmateur!

    Thanks for your appreciation. To get more helpful content with explanations stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  373. Hello, Mubashir!

    Thanks for your appreciation. To get more helpful content stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  374. Glad to hear that.

    Regards
    ExcelDemy

  375. Thanks for your appreciation.

    Regards
    ExcelDemy

  376. Hello!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  377. Hello, Andy W!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  378. Hi, Dhaval!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  379. Hello, Pankaj!

    We are glad to know that it worked for you. To get more useful content stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  380. Hello, Suzette!

    Thanks for your appreciation. We will try to use fonts that will be easier to read for old eyes.

    Regards
    ExcelDemy

  381. Hello, Eric!

    Thanks for your appreciation. To get more helpful content stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  382. Hello, Instast!

    Thanks for your appreciation. To get more helpful content stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  383. Greetings ASHISH PANT,
    I appreciate you asking this question. We use the Microsoft Office 365 version here. In order to resolve your problem, you need to open the Excel workbook in Microsoft Office 365 version.

    Regards
    ExcelDemy

  384. Hello, Andre!

    Thanks for your appreciation. To get more helpful posts stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  385. Hello, Michelet!

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  386. Hello, Im!

    Hope you are doing well. Thanks for your appreciation.

    Regards
    ExcelDemy

  387. Hello, Leslie!

    Hope you are doing well. Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  388. Hello, Aston!

    Hope you are doing well. To show your data labels in millions kindly follow this article Millions in Data Labels

    Regards
    ExcelDemy

  389. Hello, Chan!

    Hope you are doing well. Glad to know that our content is useful for you.

    Regards
    ExcelDemy

  390. Hello, Kim!

    Thanks for your appreciation. For more useful content visit our site ExcelDemy.

    Regards
    ExcelDemy

  391. Hello, Suki Nasoordeen!

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  392. Hello Gerald,
    Do you need to know the conversion from Excel to PDF? Right? Because the original bank statement was in PDF format. So, here you can follow the steps below to convert your Excel file back to PDF file.
    Firstly, you need to open your Excel file.
    Secondly, click the File button at the top-left corner of the Excel file.

    edit bank statement, converting Excel into PDF

    Thirdly, go to Save As and click it.

    edit bank statement, conversion

    Fourthly, choose PDF from the Save option at the top-right corner by clicking the drop-down button.

    conversion from Excel to PDF

    Finally, choose a particular location to keep it by selecting Browse button.

    conversion from Excel to PDF

    Thanks
    Regards
    ExcelDemy

  393. Hello, Chole Faulkner!

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  394. Hello, SS!

    Hope you are doing well. We are very sorry that you are facing some troubles with advertising. But will try our best to give you a nicer experience.

    Regards
    ExcelDemy

  395. Hi Zidane

    Hope you are doing well. Thanks for your appreciation.

    Regards
    ExcelDemy

  396. Hi Peter

    Thanks for your appreciation.

    Regards
    ExcelDemy

  397. Hi Mohammed Hassen,

    Thank you so much.

    Thanks
    Regards
    ExcelDemy

  398. Hi N,

    Thanks for your appreciation. Please visit our site for more excel-related problems.

    Thanks

    Regards
    ExcelDemy

  399. Hi Bernadeth,

    Thanks for your appreciation. To get more useful content kindly visit our site.

    Thanks
    Regards
    ExcelDemy

  400. Hi GIRIDAR N,

    Thanks for your appreciation and we are glad to help you. For any types of Excel-related problems kindly reach out to us.

    Regards
    ExcelDemy

  401. Hello Marian,

    There are some unwanted issues that may arise while dealing with the VBA code. In that case, you need to utilize the following code.

    Sub Extract_Data_from_PDF()
    
    Dim MyWorksheet As Worksheet
    
    Set MyWorksheet = ActiveWorkbook.Worksheets("Sheet1")
    Application_Path = "C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe"
    PDF_Path = "C:\Users\USER\Desktop\Durjoy\Comments\New folder\standardnormaltable.pdf"
    
    Shell_Path = Application_Path & " """ & PDF_Path & """"
    Call Shell(pathname:=Shell_Path, windowstyle:=vbNormalFocus)
    
    Application.Wait Now + TimeValue("0:00:03")
    
    SendKeys "%vpc"
    SendKeys "^a"
    SendKeys "^c"
    
    On Error Resume Next
    Range("A1").PasteSpecial
    
    Call Shell("TaskKill /F /IM Acrobat.exe", vbHide)
    
    End Sub

    Here, the Application path and pdf path need to be defined accurately. Then, when you run the code, you will find the copied items in the clipboard.
    Then, click on Paste all to extract values.

    null

    Thanks
    Author, ExcelDemy

  402. Hi Exceler,

    Here, I tried the first method for 50 sets of data and it worked but you have to change the cell references based on your dataset. For your better understanding, I am attaching the images along with the formula.
    =INDEX($D$5:$D$30,MATCH(1,MMULT(--($B$5:$C$30=F5),TRANSPOSE(COLUMN($B$5:$C$30)^0)),0))

    The images of datasets

    Image of dataset

    Here, I used the formula for the entire dataset. I changed the references based on my dataset.

    Formula

    Output for 50 values:

    Output

    Note: If your dataset is very large kindly send us your dataset

    Thanks
    Shamima Sultana

  403. Hi Tom Lynham

    Hope you are doing well. Here, I updated the article which implies the title and the explanation.

    By following above explained methods it is possible to print colorful gridlines but you must use a color printer.

    If this update doesn’t help you or you have further queries kindly let us know.

    Thanks
    Shamima Sultana

  404. Hello Mark,

    We uploaded the Excel files again, you can check these files also. If you find any difficulty opening the file let us know.

    Thanks

  405. Hello Mark,
    Hope you are doing well.
    Whenever I try to download this workbook it works fine without a password. To be reassured a couple of my teammates also downloaded this file they also didn’t face any difficulty.
    As I haven’t used any password for this worksheet. I really want to know what caused such issues while you downloaded the file.
    Here, I will show you what it looks like when I download the file again.

    After downloading the file Excel shows a warning message. You have to click on Enable Editing.

    Excel sheet name in formula dynamic

    Later, the downloaded file will be available to use or you can make any changes you want.

    Solution

    N.B. If this solution doesn’t work for you. Kindly sent me the screenshots of the problem.

    Thank you.

    Regards
    Shamima Sultana

  406. Hi Froggy,
    Hope you are doing well. Thanks for reaching out to us with your issue.

    As you intend to apply the above code to a workbook with multiple sheets so you need to add some extra lines in your code to define all available worksheets or selected worksheets.

    Here, I will give you two solution
    1. For selected sheets
    2. For all the available sheets in a workbook

    1. If you want to apply the same code in some selected sheets then use the code given below where I declared sheets names by using an Array.

    Option Explicit
    Sub AddSpaceBetweenRows()
    Dim all_sheets As Worksheet
    Dim rng As Range
    Dim i As Long
    Dim all As Variant

    Set all = sheets(Array(“VBA1”, “VBA2”))

    For Each all_sheets In all
    all_sheets.Select
    Set rng = Range(“B5:E9”)
    For i = rng.Rows.Count To 2 Step -1
    rng.Rows(i).EntireRow.Insert
    Next i
    Next
    End Sub

    2. To loop through all the available sheets of your workbook you will need to use the code given below where I declared all_sheets and used an extra For Loop.

    For your better understanding, I’m providing the modified code here,

    Option Explicit
    Sub AddSpaceBetweenRows()
    Dim all_sheets As Worksheet
    Dim rng As Range
    Dim i As Long

    For Each all_sheets In Worksheets
    all_sheets.Select
    Set rng = Range(“B5:E9”)
    For i = rng.Rows.Count To 2 Step -1
    rng.Rows(i).EntireRow.Insert
    Next i
    Next
    End Sub

    Note: Based on your Excel file you will need to change the sheet name and the cell range selection.

    For further queries comment down below.

  407. Hello Naveed,

    Hope you are doing well. Kindly send me the details of your problem including the Excel file via my Gmail account [email protected]

    Thank you

  408. Hi Helen,
    I’m glad that our article helped you. For any types of Excel related problems kindly check out our ExcelDemy site.

    Thanks
    Shamima

  409. Hello Michelle,
    Hope you are doing well. If you need to run the macro after the first use it will create new sheets with the updates you made on your dataset.

    It won’t automatically update the workbooks created previously (Book1, Book2, and Book3) rather it will create Book4, Book5, and Book6 with the updated dataset.

    Thanks
    Shamima Sultana

  410. Hi A,

    Thanks for your appreciation.

  411. Hi Sikander,
    Hope you are doing well.
    To get the DateValue for February, click on the drop-down option of Month and then select February.

    monthly staff attendance

    Then you will get the DateValue and the rest will be updated automatically.

    2. Monthly Stuff Attendance

    Note: If you want to type the month name in that cell you have to be careful with the spelling of the month name.

    Thanks

    Regards
    Shamima Sultana

  412. Hi Deon Bailey,
    Hope you are doing well. Thanks for reaching out to me with your issue.

    As you didn’t share your Excel file that’s why it is hard to understand your sheet name and where is the problem occurring.

    But you need not to worry, I’m giving you a possible solution so that you can add data to your selected sheet to the last row.

    The reason for overwriting the added data is your code wasn’t finding the last row it was showing 1 as the last row number.

    Here, I added data according to my dataset I used in this article. I commented out your code and added some required lines.

    Sub Insert_Value_from_LastRow()

    ‘TargetSheet = Cmb_Months.Value
    ‘If TargetSheet = “” Then
    ‘Exit Sub
    ‘End If
    Dim targetSheet As Worksheet
    Set targetSheet = ThisWorkbook.Worksheets(“Dataset”)
    targetSheet.Activate
    ‘lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
    LastRow = ActiveSheet.UsedRange.Rows(ActiveSheet.UsedRange.Rows.Count).Row
    MsgBox LastRow

    ‘ActiveSheet.Cells(LastRow + 6, 2).Value = Cmb_Area.Value
    ‘ActiveSheet.Cells(LastRow + 6, 3).Value = Txt_Ln_Manager.Value
    ‘ActiveSheet.Cells(LastRow + 6, 4).Value = Txt_FName.Value
    ‘ActiveSheet.Cells(LastRow + 6, 5).Value = Txt_Surname.Value
    ‘ActiveSheet.Cells(LastRow + 6, 6).Value = Txt_S_Number.Value

    ActiveSheet.Cells(LastRow + 3, 2).Value = “Rachel Ross”
    ActiveSheet.Cells(LastRow + 3, 3).Value = “Germany”
    ActiveSheet.Cells(LastRow + 3, 4).Value = “laptop”
    ActiveSheet.Cells(LastRow + 3, 5).Value = 4567

    End Sub

    Note: Whenever you want to insert or add data after a particular row it is better to see the last row number by using MsgBox. It will help you to understand why data is overlapping.

    I also added the images.

    reply of comment

    reply of comment

    For further queries, you can send me your Excel file.

    Thanks
    Shamima Sultana

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy