Delete Rows when Condition is met

[CLB]

Hello,

Need help to delete some rows. My SS is set up as follows:

RowsColumns1ABCD2Report Start Date: 4/19/103Report Finish Date: 10/9/1445Report Name671Item 110082Item 25093Item 2500

10

The reports vary slightly and the actual data may start out on A7 or A9. I need to delete everything above the actual data which can be keyed by the first row in column A that contains the number 1. So in the above example rows 1:6 would be deleted.
In the following Example rows 1:8 would be deleted.
RowsColumns1ABCD2Report Start Date: 4/19/103Report Finish Date: 10/9/1445Report Title6Projected Inventory @ Month End7891Item 1100102Item 250113Item 250012
Can someone help me along with this one?

Thanks in Advance.

[mdmackillop]

You can post a sample workbook using Manage Attachments in the Go Advanced reply section.