Hi DD,
You will need to give us a bit more info.
What is special about each line that you want to extract?
How many columns in each line?
Is the data contiguous? (are there any blank cells within the 200,000
lines?)Regards - Dave.

"deedee" wrote:

Hi,

How to extract 20 000 lines out of 200 000 lines automatically and then
transfer them to another xls file automatically. Hope I am clear enough

Thanks
--
DD