Select data based on Find text function

[arpanpanchal]

Hi friends

I have attached the file in which I want to copy data from Column A (cell A6) until macro finds (TOTAL OPERATING EXPENDITURE which is cell A63). I also want to copy from cell O6 to O63 (where TOTAL OPERATING EXPENDITURE intercept). I want to copy this data into new worksheet.

Once the data has been copied in the new tab, I want to delete rows between row 7 (next row from "Account Number & Description" to row where "Statutory Outgoings" starts).

I tried doing it but couldn't work out. Can you please help?

Appreciate your time and effort in advance.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[AB33]

Try the attached.

[arpanpanchal]

Hi

The above macro doesn't achieve the result I want. I have attached the file and highlighted cells Which are to be copied into new tab.

From Cell A6, the macro should find "TOTAL OPERATING EXPENDITURE" and select cells from A6 to A63, O6 to O63 and P6 to P63.

Once the data is copied into new tab, the macro should look for "STATUTORY OUTGOINGS" and delete the data as highlighted in the attached.

Can you please help?

Thanks a lot for your time

[AB33]

Which of the above? There are two
You did not mention column P in your original request.
Try the attached.

[arpanpanchal]

Hi AB33

This works perfect. Thanks a lot for your time and effort.