I have sheet named “RawCarData”. It contains records; 10 columns, one column is a CompanyID that can be “Ford”, “Chevy”, “Honda”, etc.
I need to create additional sheets, one for each unique CompanyID, named “Ford”, “Chevy”, “Honda”, etc. I need to the copy the data from the “RawCarData” to these new sheets based on the CompanyID. I hope this makes sense.
Is there a way to do this using formulas or some Excel script?