Help modify the VB Code to copy data between 2 text string

Hello:

I need to modify the below code so that it copies all data between String1 and String2 and then
copy all data between String3 and String4 from "Startsheet" to "Result" Sheet.

Please refer to attahced sheet.

Please Login or Register  to view this content.

Hi,

please attach a workbook with a result sheet with data !

What's the issue with the code ? Awful, I agree ! But what' the matter ?

See the Find method …

Hello:

I have attached sheet earlier.
Please open and have a look.
The code would work fine, if i change the cell A7 to "Z1/Groups" instead of what is currently "Z1/Groups /12-22-2013/01:09".
So basically the code needs to find the partial string "Z1/Groups" and copy data until 1st occurrence of "REPORT END"
Then code needs to copy data from "Z1/Financial" to 2nd occurrence of "REPORT END".
Currently it would copy until the last occurrence of "REPORT END".

Please help and let me know.

Thank You

Riz Momin

As I already had open the file and 'cause there is nothing in result sheet (‼),
I just advise you to see the Left function to compare the beginning of a cell
but, if there is a lot of lines, faster is to use the Find method …