Hello:

I have data in column A thru D in excel sheet.
There are section of data and each section is separated by text "REPORT END" in column A

I need to copy data ( A- D) between 4th and 5th "REPORT END" and paste it at cell F100.

Example :

Assume that 4th "REPORT END" is at cell A102 and 5th "REPORT END" is at A196" the i would need to copy data range A103:A195 and paste at F100

Please let me know if you have any questions.
Thanks.

Riz