Excel 2003 -

[marisam]

I have a spreadsheet with 8000 records. It is sorted by the car type. There are 70 car types. I would like to create a separate excel file for each car type. Is there a script I can use to do that?
SPREADSHEET
APP CAR TYPE
01 ACURA
02 ACURA
03 TOYOTA
From the above spreadsheet I'd like to create 2 separate files: acura and toyota.

Thanks

 

[marisam]

In the title I meant to write Separate worksheet into files.

 

[SkipVought]

Turn on your macro recorder and record doing this for one...

AutoFilter the table for one car type.

select the table

Copy

Insert a new sheet

Edit/Paste Special - VALUES

right-click the sheet tab and move the sheet to a new workbook.

Save the workbook and CLOSE

Post you code in VBA Visual Basic for Applications (Microsoft) Forum707 -- NOT in this Forum.

Skip,

_[red][/red]

 

[KenWright]

Depending on how many fields you have in your data, you might also want to throw a Pivot table at it, drag in all the data fields you want and then drag CAR up into the page fields. Now using the Pivot Table toolbar hit the 'Show Pages' icon and then choose CAR and it will create a sheet for every car.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------