Excel Importing rows from notepad to excel

[simpliienigmatic]

I have a requirement as per which I need to verify the data in the notepad by importing in excel. The note pad has 2 lakh rows (or records). I am dividing the records into 4(50K each) parts for verification (due to excel constraint as it can hold not more than 66k records). The first part of getting 50k records is easy. My question is how do I get the next 50k records in excel. After the first part, I am deleting those first 50k records (which is a real time consuming and chances of missing few records are very high) from notepad. Is there any way where I can import the records starting 50001 to 100000 from notepad to excel without deleting the first 50k records. Please let me know as it is very urgent. I am using office 2007 suite.




regds,

vijayaraj

 

[Ian]

Welcome to the forums

You may be able to use something like this Macro to split the import in to multiple sheets (I assume it will also work in Office 2007):

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q120596