Find particular data from complex data string by macro

Dear all,
Every day I am to do a job , which is very time killing activity. It is actually a complex data format , form there I am to find out a particular data to make the report good looking format. In the attached file I have used two sheets 1st sheet is “input “ (Raw data) & 2nd sheet is “output “(for display results ) . I tried to explain step by step with color mark. Please check the attachments.

Hi nur2544

This Code in the attached appears to work on your Sample Data...CTRL + x will fire the Code.

Please Login or Register  to view this content.

Hi nur2544

Will there ALWAYS be 10 Lines of Data in this Section of Data?

	A
2	PERMANENT SUBSCRIBER DATA
3	SUD
4	CAT-10 DBSG-1 CSP-255 OSB1-1
5	OSB3-1 TS11-1 TS21-1 TS22-1
6	BS3G-1 PDPCP-12 PRBT-1 REDMCH-1
7	OFA-2 PWD-0000 CFU-1 CFB-1
8	CFNRY-1 CFNRC-1 CAW-1 SOCFB-1
9	SOCFRY-1 SOCFRC-1 SOCFU-1 SOCLIP-0
10	HOLD-1 MPTY-1 CLIP-1 RED-1
11	SCHAR-0-0

Hi jaslake, No it might be vary sometime it will be 10, 8,12, 11 but not more than 20. You can think “PERMANENT SUBSCRIBER DATA” Is the data starting point & next recent 1st blank cell is the Last or finishing point of “PERMANENT SUBSCRIBER DATA” data. please check the attachment

Hi nur2544

Replace the Code with this

Please Login or Register  to view this content.

You're welcome...glad I could help. Thanks for the Rep.