how to break up data in excel?

[laFiera]

Hello,
I have two files that have 53,000 rows, and 54,000 rows of data. I need to break up these files into a file that is 1,000 rows. I've been googling the net, but so far haven't been succesful in doing this. i'm not a programmer so I cant really write macros or programs to do this for me, so before i start doing manually though, maybe somebody knows how to do this...thanks!!!

 

[RedWolf]

Have you tried using Excel's database functions? I don't have excel installed on this machine but I believe you can do the following:
Insert a row at the beginning of your records. Autofil the column with numbers. Then, go to Data, filter, autofilter. It will create drop downs on your first record (which should be column names). Do the custom filter and you should be able to filter out records by the thousands. Then copy and paste them into a new file.

Other than that, you'd have to do some programming.

 

[WW]

you mean you want to end up with 53 spreadsheets of 1000 rows, and another 54 spreadsheets of 1000 rows?

to automate, you could do a simple macro like this and it would create a new workbook for each 1000 rows....just open the workbook, make the macro and run it.

if this is something you need to do on a regular basis, you could make it save the files automatically, etc