Latest Posts From Nuraida Kashmin
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 ...
Nuraida Kashmin
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