Data sort with create tab in Excel

Posted on 2014-08-28
Last Modified: 2015-01-05
I'm trying to find a way or to see if possible, to have a macro that would sort a file that we do manually. I'm attaching a dummy file for this, but would need it to look at "Title Company" & "Part #).  1st would be to move C & D Part number to a created tab that would be "NON-Tracking", then create 4 Tabs. Group 1 Company A &B, Group 2 Company C&D, Group3 E,F,G and Group4 Company H,I,j,K.

Is something like this two step process possible to create a macro to automate?
Question by:NYANBCNY32
    LVL 31

    Expert Comment

    by:Rob Henson
    Take a look at the Advanced Filter function, this can be used to filter and copy data to another location.

    If so required it can be automated.

    Rob H
    LVL 2

    Accepted Solution

    This file copies that data for Part #s C and D to a NON-Tracking tab. It then copies the data for the remaining parts for the specified company groups to separate tabs. The original Data Sheet is not changed.

    The "real" Part #s and Title Companies will have to be customized in the macro code.

    Additional development would be required to make use of user-defined groups and a variable number of tabs.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now