Skip to content
ExcelNSG
  • Home
  • Basic
    • Excel Format Painter – An Introductory Guide
    • How to Create a Custom AutoFill List in Excel 2013
  • Blog
    • How to Remove Formulas and Keep the Values in Excel (4 Quick Ways)
    • 5 Ways to Delete Blank Rows in Excel (With VBA Macro)
    • How to Split Cells Diagonally in Excel (Step by Step Guide)
    • 3 Easy Ways to Select the Visible Cells Only In Excel
  • Function
    • Excel COUNTBLANK Function – An Introduction Guide
    • Excel COUNT Function – How to Use (with example)
    • Excel COUNTA Function – How to Use (with example)
    • How to Use Excel COUNTIF Function – with Multiple Condition
    • How to Use Excel COUNTIFS Function with Multiple Criteria
    • Excel SUM function – How to use (with example)
    • How to use Excel SUMIF Function – Multiple Condition (with examples)
  • VBA
    • Copy and Paste in Excel VBA: 4 Easiest Way (For Beginners)
    • How to Change the Background Colors in Excel VBA
    • 3 Quick Ways to Change the Font Color in Excel VBA
  • Excel Quiz
    • Shortcut Skills
  • Contact Us
  • Privacy Policy

VBA Macro to Filter Excel Data and Create Separate Sheets Based on Unique Values

Leave a Comment / Function / NSG

In this post, we explore a practical VBA macro designed to automate the process of filtering and copying data in […]

VBA Macro to Filter Excel Data and Create Separate Sheets Based on Unique Values Read More »

Mastering Excel FILTER Function: A Comprehensive Guide

Leave a Comment / Function / NSG

This tutorial will explain you about the uses of Excel FILTER function, Introduction Excel’s FILTER function is a game-changer for

Mastering Excel FILTER Function: A Comprehensive Guide Read More »

Converting a PDF Document into Excel Spreadsheet – A Step-by-Step Guide

Leave a Comment / Function / NSG

Today, we’re going to learn how to Converting a PDF Document into Excel Spreadsheet. Are you ready to discover the

Converting a PDF Document into Excel Spreadsheet – A Step-by-Step Guide Read More »

How to Separate Text and Numbers from Mixed Dataset

Leave a Comment / Function / NSG

In this blog post, I will explain to you how you can Separate Text and Numbers from Mixed Datasets. Suppose

How to Separate Text and Numbers from Mixed Dataset Read More »

How to Compare Two Excel Workbooks and Highlight Differences in Excel VBA

Leave a Comment / Function / NSG

This post will explain how we can compare the two files sheet by sheet with the VBA macro.

How to Compare Two Excel Workbooks and Highlight Differences in Excel VBA Read More »

Calculate the Difference between Two Dates Dynamically

Leave a Comment / Function / NSG

This blog post will explain to you how to Calculate the Difference between Two Dates Dynamically. Here we have two

Calculate the Difference between Two Dates Dynamically Read More »

How to Extract Data between Two Date Ranges in Excel VBA

Leave a Comment / Function / NSG

The purpose of this blog post is to extract data between two date ranges using Excel VBA. Copying data from

How to Extract Data between Two Date Ranges in Excel VBA Read More »

Combine Data from Multiple Worksheets into a Single in Excel VBA

Leave a Comment / VBA / NSG

This tutorial will explain how to summarize or combine data from multiple worksheets into a single, in the same workbook.

Combine Data from Multiple Worksheets into a Single in Excel VBA Read More »

Excel VBA Macro: – Apply Filter and Copy, Paste Data Into Another Worksheet

1 Comment / VBA / NSG

This tutorial will explain how to Apply Filter and Copy, Paste Data Into Another Worksheet in Excel VBA. Suppose, we

Excel VBA Macro: – Apply Filter and Copy, Paste Data Into Another Worksheet Read More »

3 Easy Methods to Transpose Data in Excel (Step-by-Step Guide)

Leave a Comment / Function / NSG

Using Excel, you can enhance the appearance of your worksheet with a wide range of formatting methods. This article describes

3 Easy Methods to Transpose Data in Excel (Step-by-Step Guide) Read More »

Post pagination
1 2 … 5 Next →

Get 40 VBA Code E-book for Beginner

* indicates required



Recent Posts

  • VBA Macro to Filter Excel Data and Create Separate Sheets Based on Unique Values
  • Mastering Excel FILTER Function: A Comprehensive Guide
  • Converting a PDF Document into Excel Spreadsheet – A Step-by-Step Guide
  • How to Separate Text and Numbers from Mixed Dataset
  • How to Compare Two Excel Workbooks and Highlight Differences in Excel VBA

Recent Comments

  • NSG on 3 Quick Ways to Change the Font Color in Excel VBA
  • Baranidaran on Excel VBA Macro: – Apply Filter and Copy, Paste Data Into Another Worksheet
  • Sheryl on 3 Quick Ways to Change the Font Color in Excel VBA
  • Nauman on How to Filter the Data as You Type in Excel VBA
  • NSG on How to Lock Scroll Area in Excel with VBA (Step By Step Guide)

Archives

  • July 2024
  • June 2024
  • January 2024
  • May 2023
  • March 2023
  • January 2023
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • October 2021
  • August 2021
  • June 2021
  • May 2021
  • April 2021
  • October 2020
  • July 2020
  • June 2020
  • May 2020
  • March 2020
  • January 2020
  • September 2019
  • July 2019

Categories

  • Function
  • Quiz
  • VBA

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Copyright © 2025 ExcelNSG