Hello Gmayor



The macro that you wrote, It worked excellent, its LIGHTNING FAST.

The one I had It will have to cut and then paste in new window and slow, but the one you wrote is Really Really Fast.

I press the button and all the data is extracted in the 2nd window.

Thanks a lot for all your help

Hello Gmayor

I wonder if you can help me with this macro, The macro is very similar to the earlier one except its cuts out only one block of text.

Its searches for the phone number with word " ANY CHARACTER " search, the format is in the macro and once it finds the phone number then it goes up 6 lines and cuts out a block of text.

As you can see in the output file 3 block of records are cut, ( once i have all the data like in this format then i do so search and replace to clean out the extra items from the file )

Any help would be greatly appreciated.

Thanks.

Attached Files

	macro file.doc (74.0 KB, 9 views)
	output file.doc (21.0 KB, 9 views)