# Nuraida Kashmin

About author

Hi Everyone! I am Nuraida. Cordially welcome you to my profile. I am a Team Leader of Excel and VBA Content Developer in ExcelDemy. Here I will also post articles related to Microsoft Excel. With a strong educational background in Mechanical Engineering through experimental learning from Rajshahi University of Engineering & Technology. Skilled in Microsoft Word, Creative Writing, Microsoft Excel, Project Management, Support to Organize Different Events, Reporting, Monitoring & Documentation, Online Advocacy and Event Management Related to SAP and Youth Leaders.

## Excel Find Duplicate Rows Based on Multiple Columns

Sometimes we need to find and highlight duplicate rows based on multiple columns in Excel. It makes the huge dataset attractive and easy to calculate. In this ...

## How to Split Sheet into Multiple Sheets Based on Rows in Excel

Sometimes for easy calculation, we need to split an Excel sheet into multiple sheets based on rows. In this article, we are going to learn how to do that by ...

## How to Find a Circular Reference in Excel (2 Easy Tricks)

Sometimes we input an Excel formula in a worksheet but itâ€™s not working for some reason. It shows a warning prompt instead which mentions Circular Reference. ...

## How to Trim Text in Excel

Sometimes we need to trim space or character from an entire text in Excel to make the dataset attractive. We can use different Excel functions like TRIM ...

## How to Remove Table in Excel (6 Easy Methods)

Sometimes we need to remove a table from the worksheet in Excel, although it makes the worksheet dynamic. We can also remove the table formatting style. In ...

## COUNTIF Date Is within 7 Days

Sometimes we need to count if the date is within 7 days from the dataset for quick calculation. In this case, we need to use some Excel formulas with the ...

## How to Split Data with Formula in Excel (8 Easy Ways)

We can split a cell, a text string, or a column using an Excel formula. This makes the dataset more readable and easily accessible to the correct information. ...

## How to Split One Column into Multiple Columns in Excel Formula

Excel formulas help us to find value from a long column by splitting one column into multiple columns. These make the dataset more readable and easily ...

## How to Split One Column into Multiple Columns in Excel

Sometimes it becomes difficult to find value from a long Excel column. So we need to split one column into multiple columns in Excel. It makes the dataset more ...

## How to Convert Number to Date in Excel

Sometimes in Excel, we input the date but it returns it as a bunch of numbers as it stores the date value as a number. This makes the dataset very difficult to ...

## Excel Formula to Add Date Range (11 Quick Methods)

Date Range in Excel helps us to do a calculation on date values. In this article, we are going to know more about the Excel Formula for the date range with ...

## How to Add Space between Rows in Excel

To add space between rows, we need to insert blank cells between them. We can do it manually by right-clicking, pressing the keyboard shortcut, or using the ...

## How to Use 3D SUMIF for Multiple Worksheets in Excel

Sometimes we need to sum identical ranges across the different worksheets. We can use a formula based onÂ SUMIF, INDIRECTÂ &Â SUMPRODUCTÂ functions for this ...

## Excel Cell Color: Add, Edit, Use & Remove (7 Quick Ways)

Sometimes we need to color our Excel cell to make the dataset unique, highlighted, beautiful, and easy to visualize. In this article, we will know how to color ...

## Excel INDEX MATCH If Cell Contains Text

If the cell contains the text we can use the combination of INDEX & MATCH functions to perform a smart and advanced lookup. Itâ€™s a very popular used ...

Browsing All Comments By: Nuraida Kashmin
1. Dear Coral Gray,

You are most welcome.

Regards
ExcelDemy

2. Dear Bel,

You are most welcome. We always try to provide best resources.

Regards
ExcelDemy

3. Hi Jon,
You can try this path:
Select cell range > Click on Conditional Formatting > Select New Rules > Go to â€˜Format only cells that containâ€™ option > From the Edit drop-down, select â€˜No Blanksâ€™ > Select Fill color > Press OK.

4. Hi SHANON,
Please try to apply below VBA Code after selecting the whole dataset:

Sub move_rows()
For Each myCell In Selection.Columns(2).Cells
If myCell.Value = “Closed” Then
myCell.EntireRow.Copy Worksheets(“Sheet2”).Range(“A” & Rows.Count).End(3)(2)
End If
Next
End Sub

You may replace the column number in line 2 according to the placement of your “status” column. Also the sheet name (Sheet2) in line 4 to your required sheet.

5. Hello CHARLOTTE,
Glad to hear that you liked my article.
Please check this article (Method 7)-
Use SUMIFS Function to Sum Between a Date Range from Another Sheet

I hope you will find a solution.

6. Hi SAM,
Glad to hear that you liked my article.
I think your project is based on the basic application of VLOOKUP. Please check this article (Method 1)-
https://www.exceldemy.com/compare-multiple-columns-in-excel-using-vlookup/#1_Compare_Multiple_Columns_in_Excel_and_Return_Matching_Data_Using_VLOOKUP

I hope itâ€™ll be helpful for you.

7. Hi SIVA!
You can check this article – https://www.exceldemy.com/delete-same-sheet-from-multiple-workbooks-in-excel-vba/
I hope it’ll be helpful for you.

8. It’s great to hear you liked the article. You are most welcome. Best wishes.

Advanced Excel Exercises with Solutions PDF