Latest Posts From Nuraida Kashmin
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. ...
Nuraida Kashmin
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 ...
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 ...
When working with Excel, you might encounter situations where dates are stored as numeric values, making it challenging to interpret the dataset. In this ...
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 ...
Sometimes we need to sum identical ranges across the different worksheets. We can use a formula based on SUMIF, INDIRECT & SUMPRODUCT functions for this ...
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 ...
Blank cells inside the dataset sometimes become disturbing. These also create difficulties in the calculation. There are numerous methods to remove blank cells ...
Sometimes we need to count only the specific characters in an Excel cell. Different Excel functions make this easy for us. In the article, we are going to ...
Dynamic VLOOKUP is used to find the value easily from a large amount of data in Excel. VLOOKUP means Vertical Lookup. As regular users of Excel, we all know ...
There are several Microsoft Excel functions to count rows with a value in Excel. In this article, we are going to know about them with examples and ...
In Excel, sometimes we see that in a worksheet there is a date column with a timestamp. There are some easy approaches to remove time from date in Microsoft ...
There are quite a few functions in Excel to extract text before the character quickly. In this article, we are going to know how to use them. 1. Using LEFT ...
Sometimes we need to insert a picture into an Excel cell to make the worksheet dynamic, beautiful and informative. Today we are going to learn some quick and ...
Excel can easily pull data from another sheet based on different criteria by using different functions. We don’t need to type data again and again for ...
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