Getting rows between two specific cells

sabun

New Member
Joined
Oct 19, 2006
Messages
2
I have more that 250 txt files generated from MesNews newsreader. Simplified file structure is herebelow:

---------------------
Group : aLIsveris
Computing time : 00:00:00
Statistics : from 01.01.2006 to 18.10.2006

***** Users with most messages *****
113 : Bugrahan
94 : [|| | ||| || |||] ³¹
82 : bb


***** Users with most started threads *****
44 : paragona
25 : Bugrahan
21 : m@cHka


***** Days with most messages *****
66 : 03.10.2006
61 : 13.02.2006
59 : 12.02.2006


***** Subjects with most answers *****
46 : Benzin Zamlarini Protesto Ediyoruz..
40 : D&R Rezilligi...
32 : MEB kapsamindaki Toshiba


***** Summary results *****
Total found messages : 6144 for 291 days
New threads : 1870
Total replies : 4274
Total modified threads : 1880
Total size : 10392217 bytes (10.148,65 KB)
Total lines : 168762 lines
Total users : 1292
Average number of messages by user : 4,76
Average size of messages by user : 8.043,51 bytes (7,85 KB))
Average number of lines by user : 130,62
------------------------

I need copy and save specific rows between the cells which are determined by contents of them.

Such as, I want to get rows between the cells which contains "Users with most started threads" and "Days with most messages" and save the new file into a specific location (i.e. "D:\anet\users") as txt file, without any changes to the file structure, for the all text files.

Original text files is located at the "D:\anet\data"

Thanking you already now.

p.s. I will do this four times more for different rows, but I believe that I can modify the macro :wink:
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,144,578
Messages
5,725,095
Members
422,590
Latest member
Mikeyyy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top