VBA beginner

[funkyfido]

Hi

I am new to VBA and am looking to automate a simple task.

I currently have a workbook which contains two reports on sheet1. The first report is called members. I want to search for the word "members" and then copy the entire range,across and down to sheet 2 on the same workbook. This range will alter every time I run the report. I have a blank row in between the word "members" and the actual data.

I then have another report, a few blank rows after the above report. i want to search for "premium" and then copy the entire range, across and down to sheet 3 on the same workbook. Again I have a blank row after the work premiums. This range will change every time I run the report.



How do I make my code robust so that regardless of how big my report is I can be sure it will always pick up all the data?
Thanks in advance
Liz