Latest Posts From Nuraida Kashmin
Here's the overview of a sample dataset where blank cells are removed. How to Remove Blank Cells in Excel: 10 Quick Ways Method 1 - Removing ...
Nuraida Kashmin
Method 1 - Use the Excel LEN and SUBSTITUTE Functions to Count Specific Characters in a Cell We are going to count the specific character “C” in the cells ...
Method 1 - Using a Dynamic VLOOKUP with the MATCH Function This is the sample dataset. To find an employee’s information according to the ID and display it ...
Method 1 - Selecting the Range of Cells to Count Rows with a Value We have a dataset of Microsoft products and their year versions. We can count the rows ...
Method 1 - Using the Format Cells Feature Assuming we have a dataset of Dates with Times. We are going to remove the time part and insert only the date in the ...
There are a number of functions in Excel we can use to extract text before a character quickly. Method 1 - Using LEFT and FIND Functions The LEFT function is ...
Practice Workbook Insert Picture into Cell.xlsx 3 Methods to Insert a Picture into Excel Cell Method 1 - Copy-Paste Method to Insert a Picture ...
Method 1 - Use the Advanced Filter to Pull Data from Another Sheet We have a dataset of customers and their payment history. We are going to pull out the ...
To mention the results of the formula or cell references, we use the named range. It makes our formula easy and dynamic. We can easily remember the data range ...
In this tutorial, we will explore 3 ways to delete multiple sheets in Excel, and how to do so based on different criteria. To illustrate, we have an Excel ...
For example, we have the following dataset and you see Excel is showing formulas in the cells instead of calculated results. Let’s check how we can solve this ...
We have a dataset of a List of Fruits and Their Colors. We will use Format Painter to copy the cell format. Method 1 - One-Click Process to Use the ...
Method 1 - Combine Rows with the Same ID using VBA This is the sample dataset. To merge values: STEPS: Go to the Sheet tab and right-click. ...
We have a list of employees of a company, their corresponding working days, and their salaries. We will use this dataset to add cells. Method 1 - ...
Method 1 - Viewing Two Excel Sheets Side by Side to Find Duplicates Let’s consider we have an Excel workbook with two sheets. Here, we will compare ...
See Our Reviews at
Dear Coral Gray,
You are most welcome.
Regards
ExcelDemy
Dear Bel,
You are most welcome. We always try to provide best resources.
Regards
ExcelDemy
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.
Hi Bob,
Please check this one. It might be helpful-
https://www.exceldemy.com/excel-reference-cell-in-another-sheet-based-on-cell-value/
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.
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.
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.
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.
It’s great to hear you liked the article. You are most welcome. Best wishes.
You can check this article- How to Find Duplicate Values Using VLOOKUP in Excel