LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mike_vr
 
Posts: n/a
Default Major help needed

Right, so this one is a biggy for me, and I'm stumped.

Basically, I have to analyse the mobile phone records for my company. The
invoice comes in on a disk, and now it's my job to go through all the calls
picking out certain numbers, users, etc.
Anyway, after exporting the data to a .txt file, i now need to open it in
excel so I can start comparing and so on. Unfortunately, this is a big
company and turns out, there are a lot of calls being made.
So excel is unable to open anything more than the first 65 000 odd rows of
calls. I still need a lot, lot more.
Is there any way that Excel can carry on opening the txt file in another
worksheet or something like that.
For instance, as soon as one worksheet is full, move on to Sheet 2 instead
of just stopping the opening?

If anybody has any ideas they would be greatly appreciated, 'cos there's no
way I'm going through those records manually.

Thanks a lot,
mike
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If Then help needed RGT New Users to Excel 2 March 18th 05 01:30 AM
Excel formula needed to amounts into one column pulling from 2 col Scott Excel Worksheet Functions 1 March 3rd 05 06:42 PM
Formula Advice Needed Brad_A Excel Discussion (Misc queries) 1 March 3rd 05 06:29 PM
Sumproduct help needed! Trying to excel in life but need help Excel Worksheet Functions 5 January 21st 05 09:07 PM
Help Needed With - If-Function Adrian Jones Excel Worksheet Functions 1 November 6th 04 08:57 PM


All times are GMT +1. The time now is 10:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"