VBA Macro to Search multiple TEXTs

Hi,
I have a big data file with * as field separator and #$# as line Breaker
1. It will read Policy number SAY V009876C880 from an excel file say (a.xls).
2. Then Search that policynumber from Data file.
3 If found then it will search another text 10 lines above to that policy number Line
4.Again it will search another text 20 lines below to that policy number Line
5 Then write the entire searched lines in a new excel file
6. Finally it pick next policy number from A.XLS and repeat steps.

First Search policy number -> Then search a text 10 lines above to that policy number -> Again Search another text 20 lines below to that policy number line.
Finally insert those lines in a separate excel file with policy number

Regards,
Byomakesh

Originally Posted by byomakesh

I have a big data file with * as field separator and #$# as line Breaker

Is it a Text file?

Originally Posted by byomakesh

1. It will read Policy number SAY V009876C880 from an excel file say (a.xls).

Is the policy number "V009876C880" known already?


Attach a sample workbook/Text file. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.