User Posts: Shamima Sultana
0
How to Import Data from Excel to Google Sheets (2 Easy Ways)
0

For various purposes, you may need to get data from Excel to Google Sheets. In this article, I will show you how you can import data from Excel to google ...

0
How to Convert Currency to a Number in Excel (6 Easy Ways)
0

In Microsoft Excel, it is easy to convert the currency to a number. For different types of purposes, you may need to convert your stored currencies to numbers. ...

0
Excel VBA: Merge Multiple CSV Files into One Workbook 
0

It is very common to convert CSV files to Excel files. In this article, you will get how you can Merge Multiple CSV Files into one Excel Workbook VBA. Here, I ...

0
How to Set Excel Column Width to cm Unit (with Easy Steps)
0

In this article, I will show you how you can change the Excel column width in cm. For measurements purpose, you may need to change or set the column width. ...

0
How to Create Proforma Invoice for Advance Payment in Excel
0

A Proforma invoice is used to request payments from the dedicated buyer for any items, goods, services and etc before supply. It includes details of the items ...

0
How to Filter by Text Color in Excel (5 Easy Methods)
-1

If you want to apply a Filter based on text color this is the right place for you. Here, I will explain how to filter by text color in Excel. Sometimes from a ...

2
Excel Percentile Rank Inc vs Exc
-1

Based on the dataset various times we need to rank or sort them from least to greatest. In Excel, we can use it using the PERCENTILE function. But for better ...

2
How to Format Phone Number with Extension in Excel (3 Easy Ways)
-1

You may need to format your phone numbers with an extension you can easily do it by using Excel in-built features and formulas. In this article, we will learn ...

1
If Cell Contains Specific Text Then Add 1 in Excel (5 Examples)
-1

Whenever you want to search for any specific text to do some operations you can easily do it in Excel. In this article, I’m going to show you in Excel that if ...

2
How to Shift Cells Down in Excel without Changing Formula (4 Methods)
-1

Normally Formulas are associated with the referenced cell but for any reason or circumstances if you want or wish to shift cells down in Excel without changing ...

2
Excel Formula to Calculate Average Annual Compound Growth Rate
-1

In financial data, it is very much important to know the annual growth rate. Average annual compound and annual growth rate help to distinguish where the ...

1
Hyperlink in Excel Not Working (3 Reasons & Solutions)
-1

In Excel sheets, we often use Hyperlinks to link any sheet or page. Sometimes Hyperlinks may give you reference errors or links can be broken etc. In this ...

2
How to Sort Numbers in Excel (8 Quick Ways)
-1

To do analysis or to keep numbers in order, Sorting is important. In Excel, there are a couple of ways to Sort numbers. There are two possible ways to Sort ...

0
How to Remove Read Only from Excel (7 Easiest Ways)
-1

An Excel file can be in Read Only mode for two reasons one is if any author has purposely done it for security issues otherwise anyone downloaded the file from ...

0
How to Remove Percentage in Excel (5 Quick Ways)
-1

In an Excel sheet, you can use different kinds of formats based on your need. Percentage is one of the Number Format which is used to show a relative value ...

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. Dear Duncan R Walk,

    You are most welcome.

    Regards
    ExcelDemy

  3. 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

  4. Dear Ronald,

    You are most welcome.

    Regards
    ExcelDemy

  5. Dear Ronhat Minmin,

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

    Regards
    ExcelDemy

  6. Dear Ebrahim Ahmadi,

    You are welcome.

    Regards
    ExcelDemy

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

  8. Dear Lin Giralt,

    You are most welcome.

    Regards
    ExcelDemy

  9. Dear Khin Soe,

    You are most welcome.

    Regards
    ExcelDemy

  10. Dear Tha’ir,

    You are most welcome.

    Regards
    ExcelDemy

  11. Dear Mohamad,

    Thanks for your appreciation

    Regards
    ExcelDemy

  12. Dear Minhajul,

    You are most welcome.

    Regards
    ExcelDemy

  13. Dear Sandeep Bhattacharjee,

    You are most welcome and thanks for your appreciation.

    Regards
    ExcelDemy

  14. 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

  15. Dear S Roy,

    You are most welcome.

    Regards
    ExcelDemy

  16. Hi Kazem,

    You are welcome.

    Regards
    ExcelDemy

  17. Dear Lana,

    You are most welcome.

    Regards
    ExcelDemy

  18. Dear Seamus Madden,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  19. Hi Ndonwi,

    Thanks

  20. Dera Merc,

    You are most welcome.

    Regards
    ExcelDemy

  21. Dear Joanna,

    You are most welcome.

    Regards
    ExcelDemy

  22. Dear Richard,

    You are most welcome.

    Regards
    ExcelDemy

  23. Dear Andrei,

    These functions are available in WPS office.

    Regards
    ExcelDemy

  24. Dear Kapil,

    You are most welcome.

    Regards
    ExcelDemy

  25. Dear Tommy Fuifui,

    You are most welcome.

    Regards
    ExcelDemy

  26. Dear Excel Nob,

    You are most welcome.

    Regards
    ExcelDemy

  27. Dear Car,

    You are most welcome.

    Regards
    ExcelDemy

  28. Dear Jamie,

    You are most welcome.

    Regards
    ExcelDemy

  29. Dear Anitelleth,

    You are most welcome.

    Regards
    ExcelDemy

  30. Dear Anitelleth,

    You are most welcome.

    Regards
    ExcelDemy

  31. Dear Kay,

    You are welcome.

    Regards
    ExcelDemy

  32. Dear Pirooz Rahimi,

    You are most welcome and thanks for your appreciation.

    Regards
    ExcelDemy

  33. Dear Abel,

    Thanks for your appreciation. You are most welcome.

    Regards
    ExcelDemy

  34. Dear Kh Paydar,

    You are most welcome.

    Regards
    ExcelDemy

  35. Dear Joris,

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

    Regards
    ExcelDemy

  36. Dear Raja,

    You are most welcome.

    Regards
    ExcelDemy

  37. Dear Kapil,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  38. Dear Polepeddi Sasidhar,

    We are glad to hear that.

    Regards
    ExcelDemy

  39. 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

  40. Dear Jidith Savidge,

    You are most welcome.

    Regards
    ExcelDemy

  41. Dear Ajij Nadaf,

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

    Regards
    ExcelDemy

  42. 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

  43. 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

  44. 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

  45. 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

  46. 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

  47. 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.

  48. Dear Aspen,

    You are most welcome.

    Regards
    ExcelDemy

  49. Thanks for your suggestions.

  50. Dear Victor,

    You are most welcome.

    Regards
    ExcelDemy

  51. Dear Elizabeth,

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

    Regards
    ExcelDemy

  52. Dear Anjli Gupta,

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

    Soluation-of-Advanced-MCQs-for-Exam

    Regards
    ExcelDemy

  53. Dear HG,

    You are most welcome.

    Regards
    ExcelDemy

  54. Dear Seaunders,

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

    Regards
    ExcelDemy

  55. Dear Gunawan,

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

    Regards
    ExcelDemy

  56. 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

  57. Dear Rafi,

    Thanks for your appreciation.

    Regards
    ExcelDemy

  58. 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

  59. Dear Rashmi,

    You are most welcome.

    Regards
    ExcelDemy

  60. Dear Jay Dee,

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

    Regards
    ExcelDemy

  61. Dear Silver,

    You are most welcome.

    Regards
    ExcelDemy

  62. Dear William B,

    You are most welcome.

    Regards
    ExcelDemy

  63. Dear Eugen Safta,

    You are most welcome.

    Regards
    Shamima Sultana | ExcelDemy

  64. Dear Radu,

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

  65. Dear Sanket,

    Thanks for your appreciation.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  66. 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

  67. 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

  68. 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

  69. Hi Robert Bakinam,

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

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  70. Dear German,

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

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  71. Dear Kirsten Wheeler,

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

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  72. Dear NancyM,

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

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  73. Dear CJvW,

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

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  74. Dear Geogre,

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

  75. Dear Michael Gamal Aziz,

    You are most welcome.

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  76. Dear Glenn,

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

    Regards
    Shamima Sultana
    Project Manager | ExcelDemy

  77. 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

  78. 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

  79. 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

  80. Dear Mody,

    Thanks for your appreciation.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  81. Hello Joanie,

    You are most welcome.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  82. Dear Map,

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

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  83. Dear Ven Upekkha,

    Thanks for your appreciation.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  84. Dear Rajesh,

    You are welcome.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  85. Dear umit,

    Thanks for your appreciation it means a lot to us.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  86. Hello Zuri,

    Thanks for your suggestion.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  87. Dear Carl,

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

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  88. 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

  89. Dear Micah,

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

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  90. Dear Mukibul Hasan,

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  91. Dear Shanmuga Raja V S,

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    Shamima Sultana | Project Manager | ExcelDemy

  92. Dear Adam,

    Thanks for your appreciation.

    Shamima | Project Manager | ExcelDemy

  93. Dear Zidane,

    Thanks for your appreciation.

    Shamima | Project Manager | ExcelDemy

  94. Dear Kayla,

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

    Regards
    Shamima | Project Manager | ExcelDemy

  95. Hello Uday Kumar,

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

  96. Dear Forte,

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

    Regards
    Shamima | Project Manager | ExcelDemy

  97. Dear Gilson,

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

    Regards
    Shamima | Project Manager | ExcelDemy

  98. Dear Gerry Conroy,

    You are most welcome.

    Regards
    Shamima | Project Manager | ExcelDemy

  99. Dear Syed Anwar Hussain,

    Thanks for your appreciation.

    Regards
    Shamima | Project Manager | ExcelDemy

  100. Hello, Xzavier!

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

    Regards
    ExcelDemy

  101. Hello, An!

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

    Regards
    ExcelDemy

  102. Hello, James!

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

    Regards
    ExcelDemy

  103. Hi Rassulsson!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  104. 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.

  105. Hello, Hamza!

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

    Regards
    ExcelDemy

  106. 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

  107. Hello, Nabil sellami!

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

    Regards
    ExcelDemy

  108. Hello, JeteMc!

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

    Regards
    ExcelDemy

  109. Hello, Helen!

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

    Regards
    ExcelDemy

  110. Hi, Irene!

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

    Regards
    ExcelDemy

  111. Hi, Elton!

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

    Regards
    ExcelDemy

  112. Hello, Muhammad Luqman!

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

    Regards
    ExcelDemy

  113. Hi, Bosco!

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

    Regards
    ExcelDemy

  114. 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

  115. Hello, Aleksandra!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  116. Hello, Bennie!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  117. Hello, Harry!

    You can download the copy from Download Sample Workbook

    Regards
    ExcelDemy

  118. Hello, Emil Lazar!

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

    Regards
    ExcelDemy

  119. 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]

  120. Hello, Nastaran!

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

    Regards
    ExcelDemy

  121. 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

  122. Hello, Tanael Wawe!

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

    Regards
    ExcelDemy

  123. Hello, Tanael Wawe!

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

    Regards
    ExcelDemy

  124. Hello, Dan!

    Thanks for your appreciation. It means a lot.

    Regards
    ExcelDemy

  125. Hello, Ahnaf!

    You are most welcome. stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  126. Hello, Aleem!

    Thanks for your appreciation. stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  127. Hello, Mohan!

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

    Regards
    ExcelDemy

  128. Hello, Many!

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

    Regards
    ExcelDemy

  129. Hello, ExcelAmateur!

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

    Regards
    ExcelDemy

  130. Hello, Mubashir!

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

    Regards
    ExcelDemy

  131. Glad to hear that.

    Regards
    ExcelDemy

  132. Thanks for your appreciation.

    Regards
    ExcelDemy

  133. Hello!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  134. Hello, Andy W!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  135. Hi, Dhaval!

    Thanks for your appreciation.

    Regards
    ExcelDemy

  136. Hello, Pankaj!

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

    Regards
    ExcelDemy

  137. Hello, Suzette!

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

    Regards
    ExcelDemy

  138. Hello, Eric!

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

    Regards
    ExcelDemy

  139. Hello, Instast!

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

    Regards
    ExcelDemy

  140. 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

  141. Hello, Andre!

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

    Regards
    ExcelDemy

  142. Hello, Michelet!

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  143. Hello, Im!

    Hope you are doing well. Thanks for your appreciation.

    Regards
    ExcelDemy

  144. Hello, Leslie!

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

    Regards
    ExcelDemy

  145. Hello, Aston!

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

    Regards
    ExcelDemy

  146. Hello, Chan!

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

    Regards
    ExcelDemy

  147. Hello, Kim!

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

    Regards
    ExcelDemy

  148. Hello, Suki Nasoordeen!

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  149. 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

  150. Hello, Chole Faulkner!

    Thanks for your appreciation. Stay in touch with ExcelDemy.

    Regards
    ExcelDemy

  151. 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

  152. Hi Zidane

    Hope you are doing well. Thanks for your appreciation.

    Regards
    ExcelDemy

  153. Hi Peter

    Thanks for your appreciation.

    Regards
    ExcelDemy

  154. Hi Mohammed Hassen,

    Thank you so much.

    Thanks
    Regards
    ExcelDemy

  155. Hi N,

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

    Thanks

    Regards
    ExcelDemy

  156. Hi Bernadeth,

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

    Thanks
    Regards
    ExcelDemy

  157. 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

  158. 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

  159. 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

  160. 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

  161. 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

  162. 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

  163. 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.

  164. 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

  165. 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

  166. 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

  167. Hi A,

    Thanks for your appreciation.

  168. 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

  169. 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
Logo