Divide a worksheet in two and save as discreet csv files

[CDandVinyl]

Hi All

I need to divide my worksheet in two , and save each half to a named
directory as discreet CSV files named part 1 and part 2.

As the amount of lines is variable , it would need to work out the half-way
point and divide there , so saving out the top half and bottom halves.
Headers would need to be present in both.

Can someone help with this?

Best wishes

[Alf]

Perhaps something like this could work for you?

Macro assumes data starts on row 1

Please Login or Register  to view this content.

Alf

[CDandVinyl]

Hi Alf

Ok thanks for this.

I gave it a go an it's nearly there. It needs to save as csv please , and could name the two parts as 'part one' and 'part two'. I think also , rather than hiding the two halves it could delete so that the two saved parts have the header rows in place and the top and bottom rows in place.

For example this :

First Name Second Name

John Smith
Jill Jones
Bill Rodgers
Emily Johns

Would become (part 1.csv)


First Name Second Name

John Smith
Jill Jones


and (part 2.csv)

First Name Second Name

Bill Rodgers
Emily Johns


Sorry if my first post was not clear enough , but I'm grateful for your help.

Best Wishes ,

[Alf]

No problem, I've added the save as csv part and you need to change the "C:\Test\" part to the drive and folder where you wish to save the result.

This macro will not make any changes to the "master file"

Please Login or Register  to view this content.

Alf

[CDandVinyl]

Hi Alf

Ok that worked perfectly first time - thanks!

I'm grateful for your time and expertise.

Best Wishes ,

[Alf]

You are welcome and thanks for feed back.

If this solves your problem don't forget to mark thread solved.

Alf

Ps

To mark your thread solved do the following:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved