G
Guest
I have a workbook with 2 worksheets
One worksheet is empty, the other is used - 26 columns by 1,000 +/- rows
Column' B' in the worksheet with data has either a "1" or "2" in it.
The worksheet is sorted by column 'B' assending so all the '2's are on the
bottom
I search column 'B' to FIND the first '2'. When I find it I am in Column 'B'.
This is where I need help. Using Excel VB programing
I want to cut this and all following (entire) rows with data (from column
'A' to 'Z')
and go to the empty worksheet and paste all cut rows.
I am using Excel 2002.
Thank You In Advance
Bill
One worksheet is empty, the other is used - 26 columns by 1,000 +/- rows
Column' B' in the worksheet with data has either a "1" or "2" in it.
The worksheet is sorted by column 'B' assending so all the '2's are on the
bottom
I search column 'B' to FIND the first '2'. When I find it I am in Column 'B'.
This is where I need help. Using Excel VB programing
I want to cut this and all following (entire) rows with data (from column
'A' to 'Z')
and go to the empty worksheet and paste all cut rows.
I am using Excel 2002.
Thank You In Advance
Bill