Nujat Tasnim

About author

Nujat Tasnim, BSc in Computer Science and Engineering from American International University-Bangladesh, has a year-long tenure with ExcelDemy. Initially a Content Developer at SOFTEKO, she transitioned to the Software Team as Junior Software Quality Assurance Engineer. Currently serving as a Junior SQA Engineer at SOFTEKO, she excels in SDLC, STLC, and requirement analysis and possesses profound insights into OOP-related software development processes. Nujat is also proficient in design software like Photoshop and Illustrator, contributing diverse skills to her professional repertoire.

Designation

Junior Software Quality Assurance (SQA) Engineer in SOFTEKO.

Lives in

Dhaka, Bangladesh.

Education

B.sc in Computer Science and Engineering (CSE), American International University- Bangladesh.

Expertise

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

Experience

  • Technical Content Writing
  • Teaching Assistant
    • Worked as a Teaching Assistant at American International University- Bangladesh (AIUB).
  • Undergraduate Projects
    • Find Nearby Doctor
    • Manual Testing Project
    • Database Management System
    • Restaurant Reservation Management System

Summary

  • Currently working as Junior Software Quality Assurance (SQA) Engineer in SOFTEKO.
  • Started technical content writing of Excel & VBA in January 2023 later shifted as Junior Software Quality Assurance (SQA) Engineer in the Software Team.
  • Worked as a Teaching Assistant from June 2021 - August 2021 at American International University- Bangladesh (AIUB).

Latest Posts From Nujat Tasnim

0
How to Open, Run and Turn Off Excel Safe Mode (Complete Guideline)

This tutorial was prepared using Microsoft 365, but the operations apply to all versions of Excel. ⏷What Is Safe Mode in Excel? ⏷Open Excel in Safe ...

0
How to Calculate Median in Excel Pivot Table (2 Easy Ways)

The pivot table feature in Microsoft Excel can be used to sort, analyze, and share data, but pivot tables do not calculate median values, which can be ...

0
Excel VBA ComboBox with Control Source Property: 2 Methods

Method 1 - Using ComboBox Property Step 1: Creating VBA UserForm With ComboBox in Excel Create a UserForm with ComboBox. To create a Userform containing ...

0
How to Create Running Subtraction Total in Excel (2 Easy Ways)

We'll use a concise dataset of 11 rows and 6 columns, which are Region, Rep Name, Item, Units, Unit Cost, and Total. Method 1 - Using Basic ...

0
How to Create Multiple Regression Scatter Plot in Excel

What Is Multiple Regression? Multiple regression is a mathematical technique that makes statistically based predictions about a dependent variable by using ...

0
How to Use Excel VBA to Delete Table Rows (9 Examples)

    To demonstrate the different ways of deleting rows from an Excel table using VBA, we have a dataset table with 11 rows and 4 columns: ID, ...

0
Excel VBA to Vlookup Values for Multiple Matches: 2 Methods

Method 1 - Excel VBA Code to Vlookup Values for Multiple Matches 1.1. Return Multiple Values for Matches in One cell with Separators in Between with VBA We ...

0
How to Create a Circular Radar Chart in Excel (with Easy Steps)

Step 1 - Creating Dataset to Make a Circular Radar Chart Create a dataset in the following format. Step 2 - Employing Radar Chart Option ...

0
How to Show Total in Excel Pie Chart: 2 Effective Ways

Method 1 - Using Text Box in Pie Chart to Show Total Step 1: Inserting Pie Chart Select the preferred range for which you want to create the Pie Chart. ...

0
How to Use ‘Named Range’ in Excel VLOOKUP Function (2 Ways)

  Method 1 - Using Excel VLOOKUP Function with Named Range Steps: Select the range for which you want to give a name. In this dataset, C5:E14 is ...

1
How to Find Largest Number in Excel (2 Easy Ways)

We'll use a large dataset and determine the largest number from it. The image shows the overview of the functions we'll use. How to Find the Largest ...

0
How to the Use the COUNTIF and the ISNUMBER Functions to Count Numbers in Excel – 4 Examples

This is an overview. The sample dataset has 4 columns: Rep. Name, Item, Units & Unit Cost and 13 rows. You want to find the total number of ...

Browsing All Comments By: Nujat Tasnim
  1. Hi NISHANT,
    Thank you for your comment. We are sorry that the provided possible solutions aren’t working for you. Before discussing the issue I want to remind you that the Stocks and Geography command under the Data Types tab is only available in Microsoft Office 365. The Data Type tab under the Data ribbon is not available except for Microsoft Office 365.

    First, let me mention the three conditions that you must fulfill to show the Data Type tab.
    ● Need to be an Office 365 Subscriber.
    ● Editing Language should be set to English.
    ● Need to sign in to the Office application with your Office 365 account.

    Note: You will not be able to use the Data Type tab under the Data ribbon when offline.

    Please check whether all three conditions are met. I hope you can solve your problem by fulfilling three conditions and following the three solutions mentioned in the article.

    If you haven’t solved the problem yet, here are some other ways that might help you to solve the issue.

    Check for Updates: Make sure your Office 365 applications are up-to-date. In many cases, Microsoft releases updates and bug fixes on a regular basis, so updating your software may resolve the problem.

    Check Add-ins: Sometimes third-party add-ins cause problems. Ensure no unnecessary add-ins are enabled and restart Office.

    Create a New User Profile: Often, issues are related to user profiles. Try creating a new user profile on your computer and see if the issue persists.

    You can also provide us with the version information. Also, I would appreciate it if you would upload a screenshot of your Data tab so we can better understand your exact scenario and give suggestions in a productive manner. Please feel free to reach out to us with any other questions.

    Regards
    Nujat Tasnim
    Exceldemy.

  2. Hi JASON,
    Thank you for your comment. According to your comment, I understand that you want to alter the code so that you don’t have to choose a worksheet but instead, it enters new data on the worksheet you are currently on.

    For this, you don’t need any ListBox named ListBox1. Follow the below steps:
    ● In Step 1, while developing the UserForm to create the Data Entry Form, you don’t need to put ListBox1 as there will be no selection option according to your query.

    So the UserForm will look like the following image.
    image 1

    ● Now, in Module 1 insert the following code and save it.

    Sub Run_UserForm()
    UserForm1.Caption = “Data Entry Form”
    Load UserForm1
    UserForm1.Show
    End Sub

    image 2
    Now, you are good to go. You will not have to choose a worksheet instead, it enters new data on the worksheet you are currently on.

    Here is a sample image. I have entered data in the worksheet named Washington.
    image 3

    Hopefully, you will be able to solve your problem now. Please feel free to reach out to us with any other questions or you can send us your Excel files as well.

    Regards
    Nujat Tasnim
    Exceldemy.

  3. Hi AHMED KAMEL,
    Thank you for your comment. According to your comment, I have understood that you want to generate random numbers in a range with Excel VBA by defined number and distribute 100 random numbers on 20 cells whereas the total sum of these cells is 100.

    To solve this issue follow the below steps:

    ● Insert a new module and copy and paste the following code.

     Sub DistributeRandomNumbers()
        Dim total As Double
        Dim numCells As Integer
        Dim minValue As Double
        Dim maxValue As Double
        Dim rng As Range
        Dim cell As Range
        Dim i As Integer
    
        ' Define parameters
        total = 100
        numCells = 20
        minValue = 0
        maxValue = 10
    
        ' Clear existing values in the range
        Set rng = Worksheets("Sheet1").Range("A1:A" & numCells)
        rng.ClearContents
    
        ' Generate and distribute random numbers
        Randomize ' Initialize the random number generator
        For i = 1 To numCells - 1
            Set cell = rng.Cells(i, 1)
            cell.Value = WorksheetFunction.RandBetween(minValue, maxValue)
            total = total - cell.Value
        Next i
        ' The last cell gets the remaining value to ensure the sum is 100
        rng.Cells(numCells, 1).Value = total
    End Sub 

    ● Now, run the macro by pressing F5.

    Comment Solution-1

    This code will distribute 100 random integers across 20 cells in such a way that their sum equals 100. The random number range is specified by minValue and maxValue. Here is the final output image after running the VBA macro successfully.

    Comment Solution-2

    Change the sheet name according to yours. You can download the Excel file below.

    https://www.exceldemy.com/wp-content/uploads/2023/08/Answer.xlsm

    Hopefully, you will be able to solve your problem now. Please feel free to reach out to us with any other questions or you can send us your Excel files as well.

    Regards
    Nujat Tasnim
    Exceldemy.

  4. Hi BICKY,
    Thank you for your comment. According to your comment, I understand that you have a folder named SALE DATA and in that folder, you have another 3 folders named 2021, 2022 and 2023. Each sales year folder has two folders (JAN, and FEB) and then an Excel workbook. You want to collect sales data from all 3 years in a single workbook.

    To solve this issue follow the below steps:
    ● Insert a new module and copy and paste the following code.

    Sub CollectSalesData1()
        Dim baseFolder As String
        Dim year As Variant
        Dim month As Variant
        Dim yearFolder As String
        Dim monthFolder As String
        Dim fileName As String
        Dim wb As Workbook
        Dim ws As Worksheet
        Dim targetSheet As Worksheet
        Dim lastRow As Long
        Dim targetStartRow As Long
        Dim yearStartRow As Long
    
         ' Set the base folder path and arrays for years and months
        baseFolder = "D:\SALE DATA"
        years = Array("2021", "2022", "2023")
        months = Array("JAN", "FEB")
    
        ' Set the target sheet where you want to collect the data
        Set targetSheet = ThisWorkbook.Sheets("Sheet1")
        targetStartRow = 2
        
        Application.ScreenUpdating = False
        Application.DisplayAlerts = False
        
        For Each year In years
            yearStartRow = targetStartRow ' Reset the starting row for each year
            For Each month In months
                yearFolder = baseFolder & "\" & year & "\" & month
                fileName = Dir(yearFolder & "\*.xlsx")
                
                Do While fileName <> ""
                    Set wb = Workbooks.Open(yearFolder & "\" & fileName)
                    Set ws = wb.Sheets("Sheet1") ' Change to the appropriate sheet name
    
                    ' Calculate the next available row for the current year and month
                    Dim nextAvailableRow As Long
                    nextAvailableRow = Application.WorksheetFunction. _
                    Max(yearStartRow, targetStartRow)
    
                    ' Copy data from source sheet to target sheet
                    lastRow = ws.Cells(ws.Rows.Count, "B").End(xlUp).Row
                    ws.Range("B5:D" & lastRow).Copy targetSheet. _
                    Cells(nextAvailableRow, 2)
                    
                    yearStartRow = nextAvailableRow + lastRow - 4 ' Update starting row for next iteration
                    
                    wb.Close SaveChanges:=False
                    fileName = Dir
                Loop
            Next month
    ' Update the targetStartRow to the next available row for the next year
            targetStartRow = yearStartRow
        Next year
        
        Application.ScreenUpdating = True
        Application.DisplayAlerts = True
    End Sub

    ● Set the base folder path and the target sheet where you want to collect the data according to your PC.
    ● Run the macro by pressing F5.

    You can see that the macro successfully extracted data to the new worksheet. You can download the Excel file below.
    Answer.xlsm
    Hopefully, you will be able to solve your problem now. Please feel free to reach out to us with any other questions or you can send us your Excel files as well.
    Regards
    Nujat Tasnim
    Exceldemy.

  5. Hi BLA,
    Thank you for your comment. I think your concern lies in Method 2. In Method 2, we have used the Range.Copy method of Excel VBA to copy without a clipboard. The syntax of this method is given below:

    expression.Copy (Destination)

    This method does not copy to the Clipboard if the Destination argument is assigned. If this argument is deleted, Microsoft Excel copies the range to the Clipboard. In Method 2, we have used the Destination argument.

    Moreover, you can check the Clipboard after running the code to see if it is using the Clipboard or not.

    To check, go to the Home tab and click on the down-arrow beside the Clipboard option.

    Keeping the clipboard open, we ran the VBA code again.

    As you can see, the clipboard shows nothing on it after running the VBA code successfully.

    If you copy something in Excel, the clipboard will display the values. Hopefully, this answer will clear your confusion. Please feel free to reach out to us with any other questions or you can send us your Excel files as well.

    Regards,
    Nujat Tasnim
    Exceldemy.

  6. Hi LESLIE,
    Thank you for sharing your valuable feedback. We appreciate it very much. I understand your confusion. It is possible that a cell appears to be empty but the ISBLANK function returns FALSE for one of these 3 reasons:
    ● A regular space is present in the cell.
    ● A non-breaking space is present in the cell.
    ● It contains a zero-length string.

    A zero-length string, also known as an empty string, is a string with zero characters; as a result, when a cell contains a zero-length string, the LEN function returns 0. In Excel, both blank and empty cells appear empty; however, blank cells include a formula or value that evaluates to or represents a zero-length string, but empty cells do not.

    In this image, you can see that cell C7 appears blank, but it’s not! It contains a zero-length string created by entering a single apostrophe (‘) and formatted like other values: General.

    You can find out the Excel cells which contain zero-length strings by applying the following formula:
    ● Insert the following formula in cell D5 and press Enter.
    ● Now AutoFill the rest of the column’s cells to apply the same formula.

    =IF(AND(LEN(C5)=0,NOT(ISBLANK(C5))),"Zero-length string","Not a zero-length string")

    After that, you can remove the zero-length strings manually. Just select the cells and press the Delete key. Then sort to get the desired output.
    Hopefully, you will be able to solve your problem now. Please feel free to reach out to us with any other questions or you can send us your Excel files as well.

    Regards,
    Nujat Tasnim
    Exceldemy.

  7. Hi AIDAN,
    Thank you so much for sharing your valuable feedback. We appreciate your participation and are available to assist. I assume you wish to display page numbers at the top of your Excel spreadsheet. The following VBA code may solve your particular problem:

    1. First, follow the first 3 steps from Method 1.
    2. After that, type the following code in the module.

    Sub Page_Numbers_inHeader()
        Dim Wsheet As Worksheet
        Set Wsheet = Worksheets("Page Number in Header")    
        With Wsheet.PageSetup
            .CenterHeader = "&P"
        End With
    End Sub

    3. Now open the Macro dialog box: Developer > Macros.
    4. Select the specified Macro name which is Page_Numbers_inHeader and press Run.
    5. You will see the macro has inserted the page number in the header.

    Hopefully, you will be able to solve your problem now. Please feel free to reach out to us with any other questions or you can send us your Excel files as well.

    Regards
    Nujat Tasnim
    Exceldemy.

  8. Hi BELINDA H,

    Thank you for sharing your valuable feedback. We appreciate it very much. First of all, I apologize for the inconvenience. This code worked perfectly when I ran it again. But based on your query, we have identified some possible reasons for this error.

    The error you’re encountering in the line Set sWB = Workbooks.Open(Filename:=CurrentF) is likely due to an issue with the file path or the file itself. There are a few possible reasons for this error:

    1. Incorrect File Path: Ensure that the CurrentF variable contains a valid file path. Double-check that the file path is correct and that the file exists at that location.

    2. File in Use: If the file you’re trying to open is already open in another instance of Excel or by another user, you may encounter an error. Make sure the file is not being used by another process.

    3. File Format Compatibility: The code is designed to open Microsoft Excel workbooks with the extensions .xls, .xlsx, or .xlsm. If you’re trying to open a file with a different extension or a file that is not a valid Excel workbook, you may encounter an error. Ensure that the file you’re trying to open is in a compatible format.

    4. Security Settings: If your Excel application has certain security settings enabled, such as macro security or protected view, it may prevent the opening of certain files. Check your Excel security settings and make sure they allow for opening files from the specified location.

    By troubleshooting these possibilities, hopefully you should be able to identify the reason behind the error and resolve it accordingly. Please feel free to reach out to us with any other questions or you can send us your Excel files as well.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo