Macro to convert 10 lacks of data in to 10 part each containing 1 lacks data with 3 header

Hi,

I think we need to know a little more so that we can understand your data and what you mean by three headers.

Are you saying that you have 10 lakhs of rows, (i.e. 1000000), nearly a whole column of data. If so, and if you just want to extract 100,000 rows from the original sequence in turn, then a simple looping macro would do it.

e.g. (untested)

First name the header row say "header"

Please Login or Register  to view this content.