User Posts: Nuraida Kashmin
0
Count Duplicates in Excel Pivot Table (2 Easy Ways)
0

Sometimes we need to count the duplicates in an Excel pivot table for easy calculation. The Excel pivot table is an amazing feature. Counting duplicates is ...

0
Excel Find Duplicate Rows Based on Multiple Columns
0

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 ...

0
Split Excel Sheet into Multiple Sheets Based on Rows
0

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 ...

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

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. ...

0
How to Trim Text in Excel
0

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 ...

0
How to Remove Table in Excel (6 Methods)
0

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 this ...

0
COUNTIF Date Is within 7 Days
0

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 ...

0
Excel Formula to Split: 8 Examples
0

Excel formula helps us to split a cell or a text string or a column. This makes the dataset more readable and easily accessible to the correct information. In ...

0
Excel Formula to Split One Column into Multiple Columns (4 Examples)
0

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 ...

0
How to Split One Column into Multiple Columns in Excel (7 Easy Ways)
0

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 ...

0
How to Convert Number to Date in Excel (6 Easy Ways)
0

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 ...

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

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 ...

0
How to Add Space between Rows in Excel
0

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 ...

0
Excel 3D SUMIF for Multiple Worksheets
0

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

0
Excel Cell Color: Add, Edit, Use & Remove
0

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 ...

Browsing All Comments By: Nuraida Kashmin
  1. 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.

  2. 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.

  3. Hello CHARLOTTE,
    Glad to hear that you liked my article.
    Please check this article (Method 7)-
    https://www.exceldemy.com/excel-sumifs-with-date-range-and-multiple-criteria/#Method_7_Use_SUMIFS_Function_to_Sum_Between_a_Date_Range_From_Another_Sheet

    I hope you will find the solution.

  4. 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.

  5. 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.

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

ExcelDemy
Logo