I use Excel 2003 version. I have a sheet that contains lot of daily work info.
I need to extract info regarding a specific work and create a new sheet.
In the sheet, column 'A' has different entries in different rows. All are alphanumeric entries. But some of the rows has specific letters (always same letters) in the 5th and 6th position. I need to keep these rows and delete rest of the rows.
I am looking for a macro to do this
It will be of real great help . I can cut short the working on these from approx. 1.5 hours to just seconds.
Thanks all. I know u'll rock !!!!
I need to extract info regarding a specific work and create a new sheet.
In the sheet, column 'A' has different entries in different rows. All are alphanumeric entries. But some of the rows has specific letters (always same letters) in the 5th and 6th position. I need to keep these rows and delete rest of the rows.
I am looking for a macro to do this
It will be of real great help . I can cut short the working on these from approx. 1.5 hours to just seconds.
Thanks all. I know u'll rock !!!!