Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If Then help needed | New Users to Excel | |||
Excel formula needed to amounts into one column pulling from 2 col | Excel Worksheet Functions | |||
Formula Advice Needed | Excel Discussion (Misc queries) | |||
Sumproduct help needed! | Excel Worksheet Functions | |||
Help Needed With - If-Function | Excel Worksheet Functions |