Avadivelan TCS wrote:
Ya i need more details, Is there any macro for automatically fill the data
upto 65536 row in the Sheet1 and the remaining data in the Sheet2

Here is the macro to do what you need.

Importing text files larger than 65536 rows
http://support.microsoft.com/kb/q120596/

Cheerz,
Denzil