• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 287
  • Last Modified:

Data sort with create tab in Excel

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?
Sample-File.xlsx
0
NYANBCNY32
Asked:
NYANBCNY32
1 Solution
 
Rob HensonIT & Database AssistantCommented:
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.

Thanks
Rob H
0
 
Julie ThomasCommented:
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.
Sample-File-jt.xlsm
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now