User Posts: Nuraida Kashmin
0
Create Horizontal Balance Sheet Format in Excel
-1

To know the financial stability of a company or organization, we use the Balance Sheet. We can apply different Excel formulas and different features to create ...

0
How to Check If Value Is Between 10 and 20 in Excel
-1

Sometimes we need to check if the value is between 10 and 20 in Excel. We can see that Excel formulas and different features are made for us to solve these ...

0
How to Create a Gauge Chart in Excel (With Easy Steps)
-1

Sometimes we need to create a Gauge Chart in Excel to save our time and make our life more efficient. It is an eye-catching visualization of the minimum, ...

0
How to Hide Source Data in Excel Pivot Table (With Easy Steps)
-1

Sometimes we need to hide the source data in Excel Pivot Table to make the dataset more protected as well as more efficient. Hiding it can prevent seeing ...

0
How to Calculate Area Under Curve in Excel (2 Suitable Methods)
-1

Sometimes we need to calculate the area under the curve in Excel to make the dataset more efficient. It helps us in different fields of data science. We cannot ...

0
How to Calculate Accuracy and Precision in Excel
-1

Sometimes we need to calculate accuracy and precision in Excel. It helps us in statistics and data analysis to avoid significant data loss and minimize the ...

0
How to Break Links in Excel (3 Quick Methods)
-1

Sometimes we need to Break Links in Excel to make the dataset more efficient. Break Links means to end the connection of the external references. It helps us ...

0
How to Fix Cell Size in Excel (11 Quick Ways)
-1

Sometimes we need to fix cell size in Excel to make the dataset more attractive. By default, every Excel worksheet contains the same-sized cells. We modify ...

0
How to Copy and Paste in Excel and Keep Cell Size (7 Examples)
-1

Sometimes we need to copy and paste in Excel and keep cell size. It saves a lot of time during work. Also makes the dataset more attractive. In this article, ...

0
How to Fill Column in Excel with Same Value (9 Tricks)
-1

Sometimes we need to fill a column with the same value in Excel. It makes our dataset easy to operate and saves a lot of time. In this article, we are going to ...

0
How to Freeze Frame in Excel (6 Quick Tricks)
-1

The Excel freeze frame feature allows you to keep certain rows or columns visible as you scroll through your worksheet. This feature is useful when you have ...

0
How to Remove Semicolon in Excel (4 Methods)
-1

Sometimes we need to remove semicolon from the worksheet in Excel. Excel has some quick features as well as functions to do so. In this article, we are going ...

0
How to Count Text in Excel (7 Easy Tricks)
-1

Sometimes we need to count text in Excel for many purposes. Different excel functions and formulas make this easy for us. In the article, we are going to learn ...

1
How to Apply Conditional Formatting on Multiple Columns in Excel
-1

Sometimes we need to use Excel Conditional Formatting feature on Multiple Columns for quick calculation. This feature can scan the dataset easily and make the ...

0
Excel Conditional Formatting Formula with IF
-1

We can use the conditional formatting formula with IF in Excel for an easy calculative and attractive worksheet. In this article, we are going to learn how to ...

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)-
    Use SUMIFS Function to Sum Between a Date Range from Another Sheet

    I hope you will find a 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.

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo