CLB
04-21-2010, 11:26 AM
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.
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.