Need to Split Data into sections and sheets

[shelim481]

Hi All,

Can Someone help, ive been trying to figure out how i can use VBA to Split large number of data into sections and then into different sheets then export to text file, so i have large amount of data but it always starts at cell E5 but i want to cut 50 rows and 50 column of the data and put it into a new sheet then exports as TXT file, finally i want to repeat this until no data is left in the original work sheet.

I could have 100s or 1000s rows and columns filled but i need to be able to break it down to chunks.

Any Ideas?

[FlameRetired]

ive been trying to figure out how i can use VBA

That being the case you might consider having a Mod/Admin move your thread over to that sub-forum. (Please don't do this yourself. That's called double-posting.)

[shelim481]

I should mention in the txt file, it needs to have no speech marks, and each text file should be named in order, all the created work sheets should be closed in the end when done...

[shelim481]

This is what i got so far, its a work in progress....

Please Login or Register  to view this content.

[shelim481]

How do you loop the above code? Someone help....