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?