Mehedi Hasan Shimul

About author

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel, Verilog, Assembly, Arduino, MATLAB, Pspice, and HFSS.

Designation

Excel & VBA Content Developer at ExcelDemy in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.Sc. in Electrical & Electronic Engineering, BUET.

Expertise

Microsoft Office, C, C++, Verilog, Assembly, Arduino, MATLAB, Pspice, HFSS.

Experience

  • Technical Content Writing
  • Undergraduate Projects
    • Designing of a prototype of power factor improvement plant using zero cross technology in Arduino.
    • Automatic water level indicator and motor regulator using Arduino.
    • Mobile signal detector and buzzer.
    • Design of a 8-bit processor using Verilog.
    • Designing a stacked patch antenna implantable in brain tissue using HFSS Software.

Latest Posts From Mehedi Hasan Shimul

0
How to Compare Dates in Excel?

In this article, we will demonstrate how to compare dates in Excel. You will learn how to - Compare dates whether they are the same - Compare dates based ...

1
Bookkeeping for Truck Drivers in Excel

In this article, we explore how to make bookkeeping for truck drivers in Excel to track income, expenses, and mileage, as well as generate reports and ...

0
How to Calculate Inverse Matrix in Excel (3 Ways)

This article will show you various techniques to calculate the inverse matrix in Excel. The Inverse Matrix calculation is a fundamental linear algebraic ...

0
Excel SUMIF Function for Not Equal Criteria

In this article, we will know how to use Excel SUMIF not equal criteria. Excel's SUMIF function is a strong tool for computing sums based on predetermined ...

0
How to Create Dynamic Table in Excel: 3 Quick Ways

Learn how to create a dynamic table in Excel with techniques for mastering dynamic tables in Excel through faster data administration. Method 1 - Using ...

0
How to Make a Bill of Materials in Excel (2 Types)

  Type 1 - Making a Bill of Materials for a Single Product   Step 1. Create a Basic Dataset for Making a Bill of Materials We have taken a ...

0
Excel Scientific Notation Without e (7 Quick Tricks)

This article explores methods to convert Excel scientific notation without e to regular numbers. Scientific notation, often denoted with the "e" exponent ...

0
How to Use Excel VBA to Create Pivot Table (3 Examples)

In this article, we'll show you how to use Excel VBA to create a Pivot Table. Excel pivot tables are a valuable tool for data analysis, but manually creating ...

0
How to Run Excel VBA Do While Loop Till Cell Is Not Empty

VBA loops are an essential tool for automating data manipulation tasks in Excel. They allow you to repeat a set of instructions multiple times, saving you time ...

0
Excel VBA Error Handling in Loop (5 Best Practices)

VBA (Visual Basic for Applications) is a powerful tool that allows developers to create complex macros and automate various tasks in Microsoft Excel. However, ...

0
Excel VBA to List Files in Folder with Specific Extension 

Sometimes we need to list files with specific extensions in the Excel worksheets. Obviously, we can do it manually, but it’s quite laborious and ...

0
How to Use the Excel VBA Target Range – 4 Examples

  What Is the Target Range in Excel VBA? The Target in Excel VBA refers to the object that was last selected or clicked by the user.   How to ...

0
How to Create Slicer Drop Down in Excel (with Quick Steps)

With the slicer drop-down, you can quickly and easily filter data by selecting one or more items in the drop-down list, which instantly updates the pivot table ...

0
Export Folder Structure to Excel (3 Suitable Ways)

In today's digital age, businesses are increasingly relying on technology to streamline their operations. One important aspect of this is the organization and ...

1
How to Calculate CAPM Beta in Excel (3 Suitable Ways)

The Capital Asset Pricing Model (CAPM) is a widely-used financial model for estimating the expected return on an asset. In an article, we will show how to ...

Browsing All Comments By: Mehedi Hasan Shimul
  1. Reply Avatar photo
    Mehedi Hasan Shimul Jun 4, 2023 at 4:01 PM
    • Hi NARASIMHAN!

    Thank you for your queries. Let’s change the code a bit. Use the following code to copy the data and paste it as values.

    Sub CopyWorksheetsToNewWorkbook()
        Dim srcWorkbook As Workbook
        Dim newWorkbook As Workbook
        Dim srcWorksheet As Worksheet
        Dim newWorksheet As Worksheet
        ' Set the source workbook
        Set srcWorkbook = ThisWorkbook
        ' Create a new workbook
        Set newWorkbook = Workbooks.Add
        ' Loop through each worksheet in the source workbook
        For Each srcWorksheet In srcWorkbook.Worksheets
            ' Copy only values to the new workbook
            srcWorksheet.UsedRange.Value = srcWorksheet.UsedRange.Value
            ' Copy the data to the new workbook
            srcWorksheet.Copy After:=newWorkbook.Sheets(newWorkbook.Sheets.Count)
            Set newWorksheet = newWorkbook.Sheets(newWorkbook.Sheets.Count)
            newWorksheet.Name = srcWorksheet.Name
            newWorksheet.Cells.Copy
            newWorksheet.Cells.PasteSpecial xlPasteValues
            Application.CutCopyMode = False
        Next srcWorksheet
        ' Save and close the new workbook
        ' Replace "C:\Path\To\Save\NewWorkbook.xlsx" with your desired file path and name
        newWorkbook.SaveAs "C:\ExcelDemy\NewWorkbook.xlsx"
        newWorkbook.Close
        ' Clean up
        Set newWorksheet = Nothing
        Set newWorkbook = Nothing
        Set srcWorksheet = Nothing
        Set srcWorkbook = Nothing
    End Sub
    

    Afterward, you will see result like this.

    Copy Multiple Sheets to New Workbook as values with VBA - Excel

  2. Reply Avatar photo
    Mehedi Hasan Shimul Jun 4, 2023 at 3:36 PM
    • Hi PRANEETH!

    Thank you so much for your observation. We will rectify and update this error soon. Thanks again for your concern.

  3. Reply Avatar photo
    Mehedi Hasan Shimul Jun 4, 2023 at 3:24 PM

    Hi MIGUEL,

    We are glad, you asked the questions. It’s quite easy to import data from separate sheets and save it as separate documents. Simply, use the following code in a new module of VBA. Only, you have to change the file directory to save the doc file.

    Sub ExportWorksheetsToWord()
    Dim objWord As Object
    Dim objDoc As Object
    Dim objRange As Object
    Dim ws As Worksheet
    ' Create a new instance of Microsoft Word
    Set objWord = CreateObject("Word.Application")
    ' Make Word visible (optional)
    objWord.Visible = True
    ' Loop through each worksheet in the workbook
    For Each ws In ThisWorkbook.Worksheets
    ' Create a new Word document for each worksheet
    Set objDoc = objWord.Documents.Add
    ' Reference the range of the current worksheet
    Set objRange = ws.UsedRange
    ' Copy the range to the Clipboard
    objRange.Copy
    ' Paste the range into the Word document
    objDoc.Range.PasteExcelTable LinkedToExcel:=False, WordFormatting:=False, RTF:=False
    ' Save the Word document with the worksheet name
    objDoc.SaveAs "C:\ExcelDemy\" & ws.Name & ".docx" ' Replace with your desired file path
    ' Close the Word document
    objDoc.Close
    ' Clean up
    Set objDoc = Nothing
    Next ws
    ' Close Microsoft Word
    objWord.Quit
    ' Clean up
    Set objWord = Nothing
    Set objRange = Nothing
    End Sub

    After running the code, you will see the doc files created according to your dataset.

    output seperate doc files for each worksheet data

  4. Reply Avatar photo
    Mehedi Hasan Shimul May 28, 2023 at 3:02 PM

    Hi Anna!

    You wanted to say what will happen if we input the same word with Upper and Lower case. The fact is Excel counts Upper and Lower case characters as the same. So you won’t have any issues. Even then I am showing one way to make your data to proper format first. Then, use the formatted text in the required formula.

    • Just use the following formula to make words with a proper case.

    =PROPER(B5)

    proper case excel

    • Afterward, use the regular formula shown in the article.

    using formula for proper case text

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo